Re: [ADMIN] [pgsql-admin] Daily digest v1.3217 (11 messages)

2010-05-12 Thread Christophe Dore
Hi A hint : do you have any long running SQL requests, while there is some network-control devices like firewalls between the client and the server ? Using Oracle, we faced the same situation where a firewall in the middle broke the connection after a period of network inactivity between the cl

Re: [ADMIN] pg_restore : change schema

2010-04-01 Thread Christophe Dore
Well, that would work if the schema, when restored, is free. If not, you'd like to set the schema name in which you restore before restoring. When you use Oracle, you can, using exp/imp, change the schema you restore in by setting properly the program arguments. I understand that this is not po

[ADMIN] pg_restore : change schema

2010-04-01 Thread Christophe Dore
Hi Imagine I have used pg_dump to backup a given single schema. Is there any feature in pg_restore (8.4) that would allow to restore this schema in a schema with another name ? Thanks -- Christophe Doré