Re: [ADMIN] Configuration questions

2010-04-06 Thread Francisco Reyes
Kevin Crain writes: How do I configure postgres to lock a user's account after X failed login attempts, where X is an arbitrary number. Don't think there is a way to do that. Perhaps using an authentication mechanism that supports that and then using it to connect to Postgres.. This page may

Re: [ADMIN] pg_restore : change schema

2010-04-01 Thread Francisco Reyes
Julio Leyva writes: What about  alter schema  ? How would that help? If I understand correctly, the original poster is trying to do something like: Source DB schema1.table1 And restore it to schema2.table1 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

Re: [ADMIN] pg_restore : change schema

2010-04-01 Thread Francisco Reyes
Christophe Dore writes: 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 ? I think there isn't. If the pg_dump is ASCII and the file is small enough you could edit it.