[ADMIN] Pg-restore Only Privileges/ACL?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Is there a way to restore only the privileges/ACL of a relation or whole database? Often I've restored most of a database when some roles were missing. Usually this produces valid data and DDL except for some missing Grant statements. It's easy enou

Re: [ADMIN] Problems while restoring databases

"Jean-Yves NOLEN" writes: > [ while restoring a pg_dump backup ] > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 626; 2612 16386 PROCEDURAL > LANGUAGE plpgsql postgres > pg_restore: [archiver (db)] could not execute query: ERREUR: langu

[ADMIN] Problems while restoring databases

Hi everyone ! I am facing a problem after a lot of research has not found a solution. I hope some of you can enlighten me I will hold my position in 3 part: what I want, what I run, which is a problem. First of all I want to: Back up a database with all information (structure, data, funct

Re: [ADMIN] Is there any support like "for update wait N" in PostgreSQL?

Hello Laurenz Thank you for your rapid reply. Using statement_timeout is indeed the only-way to get a similar functionality as "for update wait N" in oracle. It doesn't affect the functionality at all. As I said in the previous mail that this porting method affects the functionality, it is final