Re: [ADMIN] two questions regarding warm-standby on 8.4

2012-02-04 Thread Kevin Grittner
Gx wrote: > I am configuring warm-standby as documented here: > http://www.postgresql.org/docs/8.4/interactive/warm-standby.html > > I am using "pg_standby", & may have it working corrrectly, but am > not sure. > > 1) The standby database never 'starts', right? > (/etc/init.d/postgresql-8.4 st

[ADMIN] two questions regarding warm-standby on 8.4

2012-01-26 Thread Gx
Hello. I am configuring warm-standby as documented here: http://www.postgresql.org/docs/8.4/interactive/warm-standby.html I am using "pg_standby", & may have it working corrrectly, but am not sure. 1) The standby database never 'starts', right? (/etc/init.d/postgresql-8.4 start" times out; I ca

Re: [ADMIN] two questions regarding warm-standby on 8.4

2012-01-23 Thread Simon Riggs
On Mon, Jan 23, 2012 at 8:05 PM, Gary Webster wrote: > Thanks for the informative replies. > > So, is Hot Standby the recommended way to do HA? > My application does not need to be able to do queries on the standby. Streaming replication is the recommended way to do HA, which is roughly "yes".

Re: [ADMIN] two questions regarding warm-standby on 8.4

2012-01-23 Thread Gary Webster
Hello. Thanks for the informative replies. So, is Hot Standby the recommended way to do HA? My application does not need to be able to do queries on the standby. On Mon, Jan 23, 2012 at 9:53 AM, Simon Riggs wrote: > On Mon, Jan 23, 2012 at 2:48 PM, Gary Webster wrote: > > > I am configuring w

Re: [ADMIN] two questions regarding warm-standby on 8.4

2012-01-23 Thread Simon Riggs
On Mon, Jan 23, 2012 at 2:48 PM, Gary Webster wrote: > I am configuring warm-standby as documented here: > http://www.postgresql.org/docs/8.4/interactive/warm-standby.html > > I am using "pg_standby", & may have it working corrrectly, but am not sure. > > 1)  The standby database never 'starts',

Re: [ADMIN] two questions regarding warm-standby on 8.4

2012-01-23 Thread Devrim GÜNDÜZ
Hi, On Mon, 2012-01-23 at 09:48 -0500, Gary Webster wrote: > 1) The standby database never 'starts', right? > (/etc/init.d/postgresql-8.4 start" times out; I can't connect to the > db to see if tables are correct). > > 2) Because of #1, I suppose I can't do a pg_dump on the standby db? Both a

[ADMIN] two questions regarding warm-standby on 8.4

2012-01-23 Thread Gary Webster
Hello. I am configuring warm-standby as documented here: http://www.postgresql.org/docs/8.4/interactive/warm-standby.html I am using "pg_standby", & may have it working corrrectly, but am not sure. 1) The standby database never 'starts', right? (/etc/init.d/postgresql-8.4 start" times out; I ca

Re: [ADMIN] two questions about pg 9.0

2010-10-15 Thread Guillaume Lelarge
Le 13/10/2010 23:20, Guillaume Lelarge a écrit : > Hi Kasia, > > Le 13/10/2010 22:21, Kasia Tuszynska a écrit : >> [...] >> Thanks for your reply I did a bit more testing with the superuser priv >> issue, and now I came to the conclusion that pgAdminIII may be doing >> something silly. >> > > S

Re: [ADMIN] two questions about pg 9.0

2010-10-14 Thread Guillaume Lelarge
Hi Kasia, Le 13/10/2010 22:21, Kasia Tuszynska a écrit : > [...] > Thanks for your reply I did a bit more testing with the superuser priv issue, > and now I came to the conclusion that pgAdminIII may be doing something silly. > Sure, that happens more than I would like. > I created a user: bob

Re: [ADMIN] two questions about pg 9.0

2010-10-14 Thread Kasia Tuszynska
+ can modify catalog directly This is misleading, I would call it a pgAdminIII bug but who knows maybe it is a feature... Sincerely, Kasia -Original Message- From: Guillaume Lelarge [mailto:guilla...@lelarge.info] Sent: Tuesday, October 12, 2010 10:59 AM To: Kasia Tuszynska Cc: pgsql-

Re: [ADMIN] two questions about pg 9.0

2010-10-12 Thread Guillaume Lelarge
Hi, Le 12/10/2010 19:25, Kasia Tuszynska a écrit : > [...] > 1.Permissions: > When I create a login role with superuser privileges in pgAdminIII I have the > option of indicating that the superuser will also have the permission to: > "can modify catalog directly", when I look at the sql that

[ADMIN] two questions about pg 9.0

2010-10-12 Thread Kasia Tuszynska
Hi Everybody, My environment: Windows 2008 32 bit Postgres 9.0 I have two unrelated questions: 1. Permissions: When I create a login role with superuser privileges in pgAdminIII I have the option of indicating that the superuser will also have the permission to: "can modify catalog direct

Re: [ADMIN] Two questions.

2002-10-09 Thread Bruce Momjian
exist. > > How I can to solve this problem ? > > Regards, > Fabio Bon > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]En nombre de Bruce Momjian > Enviado el: martes 8 de octubre de 2002 23:22 > Para: [EMAIL PROTECTED] > CC

Re: [ADMIN] Two questions.

2002-10-09 Thread Bruce Momjian
he file or directory does not exist. > > How I can to solve this problem ? > > Regards, > Fabio Bon > > -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]En nombre de Bruce Momjian > Enviado el: martes 8 de octubre de 2002 23:22 > Para:

Re: [ADMIN] Two questions.

2002-10-09 Thread bon
tubre de 2002 23:22 Para: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Asunto: Re: [ADMIN] Two questions. [EMAIL PROTECTED] wrote: > Hello ! > > Where I can find information, to know since one is organized the system of > files of a PostgreSQL database ? ( files of database objects ). >

Re: [ADMIN] Two questions.

2002-10-08 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > Hello ! > > Where I can find information, to know since one is organized the system of > files of a PostgreSQL database ? ( files of database objects ). > > If I have a " disc crash " or lose accidental one or several files, since I > can realize which lack? I wrote s

[ADMIN] Two questions.

2002-10-08 Thread bon
Sorry about my previous message. It wasn't clear. Where can I find information about how the system of files of a PostgreSQL database is organized ? ( files of database objects ). If I have a " disc crash " or I lose accidentally one or several files, how can I realize which are lacking ? Than

[ADMIN] Two questions.

2002-10-08 Thread Fabio C. Bon
Hello ! Where I can find information, to know since one is organized the system of files of a PostgreSQL database ? ( files of database objects ). If I have a " disc crash " or lose accidental one or several files, since I can realize which lack? Thank you very much. Fabio Bon ---

[ADMIN] Two questions.

2002-10-08 Thread bon
Hello ! Where I can find information, to know since one is organized the system of files of a PostgreSQL database ? ( files of database objects ). If I have a " disc crash " or lose accidental one or several files, since I can realize which lack? Thank you very much. Fabio Bon --