=?ISO-8859-1?Q?Henrique_Te=F3filo?= <henriquetft@xxxxxxxxx> writes: > Dumping: > pg_dump -p -U'postgres' -C -f ./dumpbkp mydatabase > tar -cvzf dumpbkp.tar.gz dumpbkp > Restoring: > cat dumpbkp.tar.gz | gunzip | psql -U'postgres' AFAICS that ought not work at all, not even a little bit. You've wrapped the dump script into a tar archive, and then not unwrapped it. The pg_dump argument list seems a bit less than kosher, as well ... doesn't -p require an argument? regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
