Exactly like @Eelke said – you’ve got in file wrote ‘create database’ so this database does not exist when you’re running script… That’s what for there is always ‘postgres’ database. Try this: pg_restore -C -d postgres -v -h xxhostxx -p 5432 -U xxuserxx test_pg_dump.dmp** And this should: connect to postgres database Create test database Disconnect … Read more
this did the trick pg_dump database_name -c -Ft -f file_name.tar pg_restore -d database_name -c file_name.tar before this i was trying to restore with out including -c(clean) even though -c is included in pg_dump it is not used in pg_restore unless we say to use…
Exclude the tables you do not want to backup pg_dump -U “postgres” -h “local” -p “5432” -d dbName -F c -b -v -f c:\uti\backup.dmp –exclude-table-data ‘*.table_name_pattern_*’ –exclude-table-data ‘some_schema.another_*_pattern_*’ The function creation code is part of the schema.
OS X 10.8 comes with pg_dump version 9.1.4 in the /usr/bin directory, along with psql and other programs that are client-side PostgreSQL tools. It does not mean that PostgreSQL as a server is installed (unless you have OS X Server Edition). So you don’t have to uninstall PostgreSQL because it’s not installed and it’s better … Read more
If you use the –clean option of pg_restore, the old tables will be dropped before the new ones are created. If you do not use the –clean option, you will get an error message that the table already exists, but pg_restore will continue processing unless you use the –exit-on-error option. If your goal is to … Read more
pg_dump –schema=masters oldDB > masters1.sql cat masters1.sql | psql newDB or in single command you can do by this pg_dump oldDB –schema masters | psql -h localhost newDB;
Looks like its the -W option. There is no value to go with that option. -W, –password force password prompt (should happen automatically) If you want to run the command without typing is a password, use a .pgpass file. http://www.postgresql.org/docs/9.1/static/libpq-pgpass.html
This was what I was looking for: pg_restore db.bin > db.sql Thanks @andrewtweber
I’m late to this party, but I feel that none of the answers are really correct. Most seem to imply that pg_dump writes a file somewhere. It doesn’t. You are sending the output to a file, and you told the shell where to write that file. In your example pg_dump test > backup.sql, which uses … Read more
ubuntu guys: most likely your pg_restore is outdated. Just use postgres doc and install newest version of postgres: Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the repository: deb http://apt.postgresql.org/pub/repos/apt/ YOUR_UBUNTU_VERSION_HERE-pgdg main where ubuntu versions are: 20.04 – focal 18.04 – bionic 16.04 – xenial Add keys: wget –quiet -O – https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo … Read more