Re: [ADMIN] pg_dump and pg_restore with different owners

Jaume Sabater <[EMAIL PROTECTED]> writes: >> But I got these errors: >> >> pg_restore: [archiver (db)] Error while PROCESSING TOC: >> pg_restore: [archiver (db)] Error from TOC entry 3751; 0 0 COMMENT >> SCHEMA public postgres >> pg_restore: [archiver (db)] could not execute query: ERROR: must b

Re: [ADMIN] pg_dump and pg_restore with different owners

Jaume Sabater wrote: Hello everyone! I am resending this email to see whether I have better luck now. I've been digging the Internet with no luck for the past few days. We have a two servers, "devel" and "live", both running PostgreSQL 8.1.8. At the devel server there is the database "ots_

[ADMIN] pg_dump and pg_restore with different owners

Hello everyone! We have a two servers, "devel" and "live", both running PostgreSQL 8.1.8. At the devel server there is the database "ots_devel" owned by user "ots_devel". At the live server there is the database "ots_live" owned by the user "ots_live". They are normal users, with no ability to