Thread: Server not starting problem

Server not starting problem

From
"Pablo Fulco"
Date:

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 connection due ti administrator command

FATAL: terminating connection due ti administrator command

FATAL: terminating connection due ti administrator command

FATAL: terminating connection due ti administrator command

Shutting down

Database system is shutdown

Logger shutting down

 

 

When I log into de pgAdminIII the server appears with a red cross, when I try to connect it sais “server doesn’t listen”

On the event viewer I have errors that say:

 

FATAL: syntax error in file c:/program files/postgresql/8.1/data/postgresql.conf” line 435, near token “MB”

 

In line 435 of the conf file I have shared_buffers = 256MB

 

When I check the services running, I have the postgresql server stopped, when I try to start it it says it started but stopped because it had no work to do????????

 

Any suggestions? I would really appreciate it

 

Pablo

Re: Server not starting problem

From
Guillaume Lelarge
Date:
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
>
> FATAL: terminating connection due ti administrator command
>
> FATAL: terminating connection due ti administrator command
>
> FATAL: terminating connection due ti administrator command
>
> FATAL: terminating connection due ti administrator command
>
> FATAL: terminating connection due ti administrator command
>
> Shutting down
>
> Database system is shutdown
>
> Logger shutting down
>
>
>
>
>
> When I log into de pgAdminIII the server appears with a red cross, when I
> try to connect it sais "server doesn't listen"
>
> On the event viewer I have errors that say:
>
>
>
> FATAL: syntax error in file c:/program
> files/postgresql/8.1/data/postgresql.conf" line 435, near token "MB"
>
>
>
> In line 435 of the conf file I have shared_buffers = 256MB
>
>
>
> When I check the services running, I have the postgresql server stopped,
> when I try to start it it says it started but stopped because it had no work
> to do????????
>
>
>
> Any suggestions? I would really appreciate it
>

You cannot use units in your configuration with the 8.1 release. Units
are available with the 8.2 release.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
PostgreSQL Sessions #3: http://www.postgresql-sessions.org