Re: [ADMIN] lock a database from new connections, without modifying pg_hba.conf
Can hba be manipulated in such a way to make Postgres read only to obtain a complete and full backup please, and if so, how? On 5/19/06, Tom Lane [EMAIL PROTECTED] wrote: Marc G. Fournier [EMAIL PROTECTED] writes: Is that possible?I've checked the docs for 8.1, and am not finding anything, nor anything in contrib ... the best I've been able to think of so far is to modify pg_hba.conf to not allow new connections for the duration of the operations I need to perform (drop and create a database) ...Not sure I understand what you need.DROP DATABASE already locks outnew connections. regards, tom lane---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriatesubscribe-nomail command to [EMAIL PROTECTED] so that yourmessage can get through to the mailing list cleanly
Re: [ADMIN] lock a database from new connections, without modifying pg_hba.conf
On Monday 10 July 2006 15:58, adey wrote: Can hba be manipulated in such a way to make Postgres read only to obtain a complete and full backup please, and if so, how? PostgreSQL allows complete and full backups while in production. E.g; we support hot backups :). You do not have to stop working just to run backups (unlike another unnamed database). Sincerely, Joshua D. Drake On 5/19/06, Tom Lane [EMAIL PROTECTED] wrote: Marc G. Fournier [EMAIL PROTECTED] writes: Is that possible? I've checked the docs for 8.1, and am not finding anything, nor anything in contrib ... the best I've been able to think of so far is to modify pg_hba.conf to not allow new connections for the duration of the operations I need to perform (drop and create a database) ... Not sure I understand what you need. DROP DATABASE already locks out new connections. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[ADMIN] lock a database from new connections, without modifying pg_hba.conf
Is that possible? I've checked the docs for 8.1, and am not finding anything, nor anything in contrib ... the best I've been able to think of so far is to modify pg_hba.conf to not allow new connections for the duration of the operations I need to perform (drop and create a database) ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [ADMIN] lock a database from new connections, without modifying pg_hba.conf
Marc G. Fournier [EMAIL PROTECTED] writes: Is that possible? I've checked the docs for 8.1, and am not finding anything, nor anything in contrib ... the best I've been able to think of so far is to modify pg_hba.conf to not allow new connections for the duration of the operations I need to perform (drop and create a database) ... Not sure I understand what you need. DROP DATABASE already locks out new connections. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly