Hi!
You need to connect to a database that exists with --dbname, for
instance --dbname=postgres. Postgres will then use that connection to
create the new database, in your case mydb.
Thank you, this seems work.
There are total 24 databases, .backup files total size in 37GB , aprox 60 %
from this from bytea columns ( pdf documents, images).
Using VPS server, 4 cores, 11 GB RAM, used only for postgres.
Which is the fastest way to restore data from all of them to empty
databases. Should I run all commands in sequence like
pg_restore --clean --create --if-exists --verbose --dbname=postgres --jobs=4
"database1.backup"
pg_restore --clean --create --if-exists --verbose --dbname=postgres --jobs=4
"database2.backup"
...
pg_restore --clean --create --if-exists --verbose --dbname=postgres --jobs=4
"database24.backup"
or run them all parallel without --jobs=4 like
pg_restore --clean --create --if-exists --verbose --dbname=postgres
"database1.backup" &
pg_restore --clean --create --if-exists --verbose --dbname=postgres
"database2.backup" &
...
pg_restore --clean --create --if-exists --verbose --dbname=postgres --jobs=4
"database24.backup" &
or some balance between those ?
Is there some postgres or Debian setting which can used during restore time
to speed up restore ?
I use shared_buffers=1GB , other settings from debian installation.
Andrus.
