Re: [ADMIN] Regarding postgres 9.1 with Redhat Linux

2011-12-02 Thread Tank.zhang
hi: " HINT: Is another postmaster already running on port 5432? If not, wait afew seconds and retry." please check system port 5432 runing? -- Original -- From: "Scott Marlowe"; Date: Sat, Dec 3, 2011 01:13 AM To: "Myint"; Cc: "pgsql-admin"

Re: [ADMIN] Regarding postgres 9.1 with Redhat Linux

2011-12-02 Thread Scott Marlowe
On Fri, Dec 2, 2011 at 2:16 AM, Myint wrote: > Dear admin, > > > >    We have installed postgres 9.1 rpm package to red hat > Linux  2.6.18- x86_64 x86_64 x86_64 GNU/Linux. After we setup and install > database we can create data folder on /app/postgres/oe. But when we try to > sta

Re: [ADMIN] Regarding postgres 9.1 with Redhat Linux

2011-12-02 Thread Kevin Grittner
"Myint" wrote: > LOG: could not bind IPv4 socket: Address already in use I suspect that the rpm set up a cluster at a default location, configured it to start automatically, and started it. You've created another cluster offering a connection on the same port. You need to just use the defau

[ADMIN] Regarding postgres 9.1 with Redhat Linux

2011-12-02 Thread Myint
Dear admin, We have installed postgres 9.1 rpm package to red hat Linux 2.6.18- x86_64 x86_64 x86_64 GNU/Linux. After we setup and install database we can create data folder on /app/postgres/oe. But when we try to start up the database as ./pg_ctl -D /app/postgres/oe start

Re: [ADMIN] Read Only Role

2011-12-02 Thread senthilnathan
Its a session variable. It can be reset(Read Write Mode) by the user itself -- View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5040717.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (p

Re: [ADMIN] Where do I get pgAgent now?

2011-12-02 Thread Anibal David Acosta
But in windows, there are no support for x64. I fact, if you have a x64 postgres version, pgAgent wont install De: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] En nombre de Julien Rouhaud Enviado el: viernes, 02 de diciembre de 2011 01:02 p.m. Para: Rob Rich

Re: [ADMIN] Where do I get pgAgent now?

2011-12-02 Thread Julien Rouhaud
On Fri, Dec 2, 2011 at 4:55 PM, Rob Richardson wrote: > I've seen lots of questions about this on the Internet, but no answers. > > I've got PostgreSQL 8.4 and 9.1 both installed on my computer. I am > trying to set up a scheduled database job to support application testing. > The problem is tha

[ADMIN] Where do I get pgAgent now?

2011-12-02 Thread Rob Richardson
I've seen lots of questions about this on the Internet, but no answers. I've got PostgreSQL 8.4 and 9.1 both installed on my computer. I am trying to set up a scheduled database job to support application testing. The problem is that I do not seem to have any of the files required to install p

Re: [ADMIN] backup non-built-in tablespace

2011-12-02 Thread Kevin Grittner
Karuna Karpe wrote: > I want get cold backup of database cluster, but in database > cluster there are four non-built-in tablespaces. So, when get the > cold backup of database cluster and restore on another machine and > I check tablespaces for that there is no any non-built-in > tablespace is a

Re: [ADMIN] Number of established connections since postmaster start

2011-12-02 Thread Florian Weimer
* Frank Lanitz: > Am 02.12.2011 11:02, schrieb Florian Weimer: >> Is there a way to monitor the number of connections which have been >> established so far? >> >> I'd like to graph this value, as a rough indicator whether connection >> pooling is working properly. > > You could check pg_stat_acti

Re: [ADMIN] Number of established connections since postmaster start

2011-12-02 Thread Frank Lanitz
Am 02.12.2011 11:02, schrieb Florian Weimer: > Is there a way to monitor the number of connections which have been > established so far? > > I'd like to graph this value, as a rough indicator whether connection > pooling is working properly. You could check pg_stat_activity table. Should include

[ADMIN] Number of established connections since postmaster start

2011-12-02 Thread Florian Weimer
Is there a way to monitor the number of connections which have been established so far? I'd like to graph this value, as a rough indicator whether connection pooling is working properly. -- Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100