Re: [ADMIN] Problem after changing the port number of postgres

2012-09-16 Thread Rural Hunter
or set the 'PGPORT' env variable. 于 2012/9/17 14:29, Devrim GÜNDÜZ 写道: Hi, On Mon, 2012-09-17 at 11:55 +0530, himanshu.joshi wrote: I have changed the default port of postgres in file "postgresql.conf" from 5432 to another four digit port which was not assigned to any one else. After th

Re: [ADMIN] Problem after changing the port number of postgres

2012-09-16 Thread Devrim GÜNDÜZ
Hi, On Mon, 2012-09-17 at 11:55 +0530, himanshu.joshi wrote: > > >I have changed the default port of postgres in file > "postgresql.conf" from 5432 to another four digit port which was not > assigned to any one else. After the change I restarted the postgres > as well as the system. But

[ADMIN] Problem after changing the port number of postgres

2012-09-16 Thread himanshu.joshi
Hi, I have changed the default port of postgres in file "postgresql.conf" from 5432 to another four digit port which was not assigned to any one else. After the change I restarted the postgres as well as the system. But after changing the port while connecting to postgres I am getting this

Re: [ADMIN] Windows Services and Postgresql 9.1.3

2012-09-16 Thread Craig Ringer
On 09/12/2012 04:48 AM, Vincent Dautremont wrote: For example, after the server had rebooted, I would stop the service from services.msc Windows then reports it as stopped but I can still see that the database is running, and can use it. Check in the process monitor (or, better, with Process

Re: [ADMIN] what is maximum allowed value of autovacuum_freeze_max_age

2012-09-16 Thread Kevin Grittner
Bruce Momjian wrote: > On Wed, Sep 12, 2012 at 10:13:38PM -0500, Kevin Grittner wrote: >> Radovan Jablonovsky wrote: >> >>> In documentation >>> http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html >>> is this information about autovacuum_freeze_max_age: "if >>> autovacuum_freeze_max_a