Re: [BUGS] postgres 9 streaming replication

2011-03-25 Thread Alex Lai
Fujii Masao wrote: On Wed, Mar 23, 2011 at 9:07 PM, Alex Lai wrote: I have no idea why I keep getting the message:\ could not connect to the primary server: FATAL: no pg_hba.conf entry for replication connection from host "slave_server_ip", user "my_super_user_name" Can you connect

Re: [BUGS] postgres 9 streaming replication

2011-03-24 Thread Fujii Masao
On Wed, Mar 23, 2011 at 9:07 PM, Alex Lai wrote: > I have no idea why I keep getting the message:\ >  could not connect to the primary server: FATAL:  no pg_hba.conf entry for > replication connection from host "slave_server_ip", user > "my_super_user_name" Can you connect from slave to master by

Re: [BUGS] postgres 9 streaming replication

2011-03-23 Thread Alex Lai
@postgresql.org Subject: Re: [BUGS] postgres 9 streaming replication On Tue, Jan 25, 2011 at 8:59 PM, Khadtare, Sharad wrote: Pls find below logfile of standby and recovery.conf in standby data directory. bash-3.2$ cat logfile LOG: database system was interrupted while in recovery at log time 2011

Re: [BUGS] postgres 9 streaming replication

2011-01-25 Thread Khadtare, Sharad
] postgres 9 streaming replication On Tue, Jan 25, 2011 at 8:59 PM, Khadtare, Sharad wrote: > Pls find below logfile of standby and recovery.conf in standby data directory. > > bash-3.2$ cat logfile > LOG:  database system was interrupted while in recovery at log time > 2011-01-

Re: [BUGS] postgres 9 streaming replication

2011-01-25 Thread Khadtare, Sharad
l-bugs@postgresql.org Subject: Re: [BUGS] postgres 9 streaming replication On Tue, Jan 25, 2011 at 5:01 PM, Khadtare, Sharad wrote: > Configured postgres 9 streaming replication and changed parameter in > postgresql.conf & pg_hba.conf file > > Problem is wal sender & receive

Re: [BUGS] postgres 9 streaming replication

2011-01-25 Thread Khadtare, Sharad
@postgresql.org Subject: Re: [BUGS] postgres 9 streaming replication -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Khadtare, Sharad wrote: > Hi, > > Configured postgres 9 streaming replication and changed parameter in > postgresql.conf & pg_hba.conf file > > Problem is wal sender

Re: [BUGS] postgres 9 streaming replication

2011-01-25 Thread Fujii Masao
On Tue, Jan 25, 2011 at 8:59 PM, Khadtare, Sharad wrote: > Pls find below logfile of standby and recovery.conf in standby data directory. > > bash-3.2$ cat logfile > LOG:  database system was interrupted while in recovery at log time > 2011-01-25 05:28:35 EST > HINT:  If this has occurred more th

Re: [BUGS] postgres 9 streaming replication

2011-01-25 Thread Fujii Masao
On Tue, Jan 25, 2011 at 5:01 PM, Khadtare, Sharad wrote: > Configured postgres 9 streaming replication and changed parameter in > postgresql.conf & pg_hba.conf file > > Problem is wal sender & receiver process not started , is there any way to > check process please suggest. What log messages did

Re: [BUGS] postgres 9 streaming replication

2011-01-25 Thread tushar
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Khadtare, Sharad wrote: > Hi, > > Configured postgres 9 streaming replication and changed parameter in > postgresql.conf & pg_hba.conf file > > Problem is wal sender & receiver process not started , is there any way > to check process please sugges