Обсуждение: pgAdmin 1.12.1 issues talking with master node of a SR-ROHS setup.
Hi pgAdmin support list, I am using pgAdmin 1.12.1 on OSX to connected to a postgresql 9.0.1 instance that is the master in a SR++ROHS pair. pgAdmin sees the master as being in recovery mode and will of course disallow me to create new tables, insert records …etc. I am able to do all of these actions via the psql client on the same machine. Is this a known bug, do I perhaps have some setting wrong ? I have verified a number of times that I am connecting to whereI think I am …etc. Thank you. -Mark
Le 17/11/2010 16:43, Mark_Sloan@McAfee.com a écrit : > Hi pgAdmin support list, > > I am using pgAdmin 1.12.1 on OSX to connected to a postgresql 9.0.1 instance that is the master in a SR++ROHS pair. > > pgAdmin sees the master as being in recovery mode and will of course disallow me to create new tables, insert records …etc. I am able to do all of these actions via the psql client on the same machine. > > Is this a known bug, do I perhaps have some setting wrong ? I have verified a number of times that I am connecting to whereI think I am …etc. > I did a quick HS+SR configuration on my laptop and it works just fine. It's on Linux but the code is not OS specific, so it shouldn't be an issue. What are the differences between the master and the slave? IP? port? can you tell us more about your configuration? -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
I found the problem. There was a modified connection pooler in-between that I had forgotten even existed... That appears to be problem for me. Sorry to bother, Mea culpa . ..: Mark On 11/17/10 10:47 AM, "Guillaume Lelarge" <guillaume@lelarge.info> wrote: >Le 17/11/2010 16:43, Mark_Sloan@McAfee.com a écrit : >> Hi pgAdmin support list, >> >> I am using pgAdmin 1.12.1 on OSX to connected to a postgresql 9.0.1 >>instance that is the master in a SR++ROHS pair. >> >> pgAdmin sees the master as being in recovery mode and will of course >>disallow me to create new tables, insert records Šetc. I am able to do >>all of these actions via the psql client on the same machine. >> >> Is this a known bug, do I perhaps have some setting wrong ? I have >>verified a number of times that I am connecting to where I think I am >>Šetc. >> > >I did a quick HS+SR configuration on my laptop and it works just fine. >It's on Linux but the code is not OS specific, so it shouldn't be an >issue. > >What are the differences between the master and the slave? IP? port? can >you tell us more about your configuration? > > >-- >Guillaume > http://www.postgresql.fr > http://dalibo.com