Victor Spång Arthursson wrote:
> Have a problem, probably easy to solve... I want to dump a database
> which resides on my local server with another, and not existing, owner
> than the one who actually owns it locally.
If the whole database is going to be owned by one user, try dumping the
tables like this:
pg_dump --no-privileges --no-owner --no-reconnect ... > tables.sql
Then load the tables as the new owner on the new database.
An alternative is to process the SQL dump using perl:
perl -p -i -e 's/old-owner-name/new-owner-name/g' tables.sql
HTH
Alex Satrapa