Re: [GENERAL] Server not starting problem

On Wed, 2012-02-01 at 11:44 -0200, Pablo Fulco wrote: > Hi all, im very new to postgres, and im having a problem with postgres 8.1. > > The thing is that the server wont start, when I checked the log it said: > > > > Received fast shutdown request > > Aborting any active transaction > > FATA

[GENERAL] Server not starting problem

Hi all, im very new to postgres, and im having a problem with postgres 8.1. The thing is that the server wont start, when I checked the log it said: Received fast shutdown request Aborting any active transaction FATAL: terminating connection due ti administrator command FATAL: terminating c

Re: [GENERAL] Server not Starting

Hi Shoaib, Thank you very much, now its working after creating the file with 256k. I also thank everyone who has supported me in this thread. Regards Raghavendra On Wed, Apr 14, 2010 at 3:44 PM, Shoaib Mir wrote: > On Wed, Apr 14, 2010 at 6:30 PM, raghavendra t > wrote: > >> Hi Shoaib, >> >>

Re: [GENERAL] Server not Starting

On Wed, Apr 14, 2010 at 6:30 PM, raghavendra t wrote: > Hi Shoaib, > > I have the file with postgres permission on it, but , surprisingly its 0k . > > [postg...@dbarhel564 ~]# cd /usr/local/pgsql/mypg/pg_clog/ > [postg...@dbarhel564 pg_clog]# ll -lh > total 0 > -rw-rw-r-- 1 postgres postgres 0 Apr

Re: [GENERAL] Server not Starting

Hi Shoaib, I have the file with postgres permission on it, but , surprisingly its 0k . [postg...@dbarhel564 ~]# cd /usr/local/pgsql/mypg/pg_clog/ [postg...@dbarhel564 pg_clog]# ll -lh total 0 -rw-rw-r-- 1 postgres postgres 0 Apr 12 12:54 [postg...@dbarhel564 pg_clog]# any step to change this

Re: [GENERAL] Server not Starting

On Wed, Apr 14, 2010 at 5:00 PM, raghavendra t wrote: > Hi Shoaib, > > Tried with pg_resetxlog > > > [postg...@dbarhel564 bin]$ pg_resetxlog /usr/local/pgsql/mypg/ > The database server was not shut down cleanly. > Resetting the transaction log might cause data to be lost. > If you want to proceed

Re: [GENERAL] Server not Starting

Hi Shoaib, Tried with pg_resetxlog [postg...@dbarhel564 bin]$ pg_resetxlog /usr/local/pgsql/mypg/ The database server was not shut down cleanly. Resetting the transaction log might cause data to be lost. If you want to proceed anyway, use -f to force reset. [postg...@dbarhel564 bin]$ pg_resetxlo

Re: [GENERAL] Server not Starting

On Wed, Apr 14, 2010 at 3:35 PM, raghavendra t wrote: > Hi, > > Log file > = > > LOG: database system was interrupted; last known up at 2010-04-12 10:53:12 > IST > LOG: database system was not properly shut down; automatic recovery in > progress > LOG: record with zero length at 0/1A0003C8

Re: [GENERAL] Server not Starting

Hi, Log file = LOG: database system was interrupted; last known up at 2010-04-12 10:53:12 IST LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/1A0003C8 LOG: redo is not required FATAL: could not access status of transaction

Re: [GENERAL] Server not Starting

Hi Ashesh Postgresql.conf file (port part of conf file) # - Connection Settings - listen_addresses = 'localhost' # what IP address(es) to listen on; # comma-separated list of addresses; # defa

Re: [GENERAL] Server not Starting

What is the value set for the port in postgresql.conf? -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Wed, Apr 14, 2010 at 10:57 AM, raghavendra t wrote: > Hi All, > > Please find the below scenario, and suggest me... > > Tryin

[GENERAL] Server not Starting

Hi All, Please find the below scenario, and suggest me... Trying to start the server, but not starting. -- [postg...@dbarhel564 mypg]$ pg_ctl -D /usr/local/pgsql/mypg/ start server starting [postg...@dbarhel564 mypg]$ psql -p 5432 -d postgre

[GENERAL] server not starting

Dear all, I am running Postgresql on windows xp. (not cygwin) I am no longer able to start the server. The pgadmin log file says: ERROR: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Since then I am no lon