pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcan not start the postgresql, i use gentoo
5+ messages / 5 participants
[nested] [flat]
* can not start the postgresql, i use gentoo
@ 2005-07-20 03:30 guo weidong <gwd1122331@yahoo.com>
2005-07-20 06:09 ` Re: can not start the postgresql, i use gentoo Peter Eisentraut <peter_e@gmx.net>
2005-07-20 07:16 ` Re: can not start the postgresql, i use gentoo Andy <frum@ar-sd.net>
0 siblings, 2 replies; 5+ messages in thread
From: guo weidong @ 2005-07-20 03:30 UTC (permalink / raw)
To: pgsql-admin
I can not run start the postgresql service, and spent
several days can not solve the problem. thanks for
anyone who can help me .
:oops: :oops: :oops: :oops: :oops:
/etc/init.d/postgresql start
* Starting PostgreSQL ...
* Please see log file:
/var/lib/postgresql/data/postgresql.log [ !! ]
and my postgresql.log is
FATAL: syntax error in file
"/var/lib/postgresql/data/postgresql.conf" line 2,
near token "/"
I dont'n know what is wrong with the postgresql.conf
Here is the config file
postgresql.conf
# PostgreSQL's Database Directory
PGDATA=/var/lib/postgresql/data
# Logfile path: (NOTE: This must be uid/gid owned by
the value of $PGUSER!)
PGLOG=/var/lib/postgresql/data/postgresql.log
# Run the PostgreSQL user as:
PGUSER=postgres
# Extra options to run postmaster with.
# If you want to enable TCP/IP for PostgreSQL, add -i
to the following:
PGOPTS="-N 1024 -B 2048 -i"
#tcpip_socket = true
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: can not start the postgresql, i use gentoo
2005-07-20 03:30 can not start the postgresql, i use gentoo guo weidong <gwd1122331@yahoo.com>
@ 2005-07-20 06:09 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 5+ messages in thread
From: Peter Eisentraut @ 2005-07-20 06:09 UTC (permalink / raw)
To: pgsql-admin; +Cc: guo weidong <gwd1122331@yahoo.com>
guo weidong wrote:
> FATAL: syntax error in file
> "/var/lib/postgresql/data/postgresql.conf" line 2,
> near token "/"
What you have there is not a valid postgresql.conf file at all. Please
read up on the documentation and write a valid one.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: can not start the postgresql, i use gentoo
2005-07-20 03:30 can not start the postgresql, i use gentoo guo weidong <gwd1122331@yahoo.com>
@ 2005-07-20 07:16 ` Andy <frum@ar-sd.net>
2005-07-20 07:55 ` Re: can not start the postgresql, i use gentoo Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
1 sibling, 1 reply; 5+ messages in thread
From: Andy @ 2005-07-20 07:16 UTC (permalink / raw)
To: guo weidong <gwd1122331@yahoo.com>; pgsql-admin
# PostgreSQL's Database Directory
PGDATA=/var/lib/postgresql/data
Is this all you have in the postgresql.conf file??? That file is usually
full with settings(most of them optional) but still...
Are u sure?
Andy.
----- Original Message -----
From: "guo weidong" <gwd1122331@yahoo.com>
To: <pgsql-admin@postgresql.org>
Sent: Wednesday, July 20, 2005 6:30 AM
Subject: [ADMIN] can not start the postgresql, i use gentoo
>I can not run start the postgresql service, and spent
> several days can not solve the problem. thanks for
> anyone who can help me .
> :oops: :oops: :oops: :oops: :oops:
> /etc/init.d/postgresql start
> * Starting PostgreSQL ...
> * Please see log file:
> /var/lib/postgresql/data/postgresql.log [ !! ]
>
> and my postgresql.log is
>
> FATAL: syntax error in file
> "/var/lib/postgresql/data/postgresql.conf" line 2,
> near token "/"
>
> I dont'n know what is wrong with the postgresql.conf
>
> Here is the config file
> postgresql.conf
>
> # PostgreSQL's Database Directory
> PGDATA=/var/lib/postgresql/data
>
> # Logfile path: (NOTE: This must be uid/gid owned by
> the value of $PGUSER!)
> PGLOG=/var/lib/postgresql/data/postgresql.log
>
> # Run the PostgreSQL user as:
> PGUSER=postgres
>
> # Extra options to run postmaster with.
> # If you want to enable TCP/IP for PostgreSQL, add -i
> to the following:
> PGOPTS="-N 1024 -B 2048 -i"
>
> #tcpip_socket = true
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: can not start the postgresql, i use gentoo
2005-07-20 03:30 can not start the postgresql, i use gentoo guo weidong <gwd1122331@yahoo.com>
2005-07-20 07:16 ` Re: can not start the postgresql, i use gentoo Andy <frum@ar-sd.net>
@ 2005-07-20 07:55 ` Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
2005-07-20 21:58 ` Re: can not start the postgresql, i use gentoo Guido Barosio <gbarosio@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Tsirkin Evgeny @ 2005-07-20 07:55 UTC (permalink / raw)
To: Andy <frum@ar-sd.net>; +Cc: guo weidong <gwd1122331@yahoo.com>; pgsql-admin
Just guessing :
The guy probably posted a conf file used by gentoo internaly NOT
/var/lib/pgsql/data/postgresql.conf .
Andy wrote:
> # PostgreSQL's Database Directory
> PGDATA=/var/lib/postgresql/data
>
> Is this all you have in the postgresql.conf file??? That file is
> usually full with settings(most of them optional) but still...
> Are u sure?
>
> Andy.
>
> ----- Original Message ----- From: "guo weidong" <gwd1122331@yahoo.com>
> To: <pgsql-admin@postgresql.org>
> Sent: Wednesday, July 20, 2005 6:30 AM
> Subject: [ADMIN] can not start the postgresql, i use gentoo
>
>
>> I can not run start the postgresql service, and spent
>> several days can not solve the problem. thanks for
>> anyone who can help me .
>> :oops: :oops: :oops: :oops: :oops:
>> /etc/init.d/postgresql start
>> * Starting PostgreSQL ...
>> * Please see log file:
>> /var/lib/postgresql/data/postgresql.log [ !! ]
>>
>> and my postgresql.log is
>>
>> FATAL: syntax error in file
>> "/var/lib/postgresql/data/postgresql.conf" line 2,
>> near token "/"
>>
>> I dont'n know what is wrong with the postgresql.conf
>>
>> Here is the config file
>> postgresql.conf
>>
>> # PostgreSQL's Database Directory
>> PGDATA=/var/lib/postgresql/data
>>
>> # Logfile path: (NOTE: This must be uid/gid owned by
>> the value of $PGUSER!)
>> PGLOG=/var/lib/postgresql/data/postgresql.log
>>
>> # Run the PostgreSQL user as:
>> PGUSER=postgres
>>
>> # Extra options to run postmaster with.
>> # If you want to enable TCP/IP for PostgreSQL, add -i
>> to the following:
>> PGOPTS="-N 1024 -B 2048 -i"
>>
>> #tcpip_socket = true
>>
>>
>>
>> ____________________________________________________
>> Start your day with Yahoo! - make it your home page
>> http://www.yahoo.com/r/hs
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: can not start the postgresql, i use gentoo
2005-07-20 03:30 can not start the postgresql, i use gentoo guo weidong <gwd1122331@yahoo.com>
2005-07-20 07:16 ` Re: can not start the postgresql, i use gentoo Andy <frum@ar-sd.net>
2005-07-20 07:55 ` Re: can not start the postgresql, i use gentoo Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
@ 2005-07-20 21:58 ` Guido Barosio <gbarosio@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Guido Barosio @ 2005-07-20 21:58 UTC (permalink / raw)
To: Tsirkin Evgeny <tsurkin@mail.jct.ac.il>; +Cc: Andy <frum@ar-sd.net>; guo weidong <gwd1122331@yahoo.com>; pgsql-admin
Those PG* parameters are env things, that you should export in your profile,
and that's why
the postgresql.conf is not a valid .conf file.
Move them out the conf file, read about ...bash? and the manual page
regarding administration / installation of postgresql.
Regards,
Guido
On 7/20/05, Tsirkin Evgeny <tsurkin@mail.jct.ac.il> wrote:
>
>
> Just guessing :
> The guy probably posted a conf file used by gentoo internaly NOT
> /var/lib/pgsql/data/postgresql.conf .
>
> Andy wrote:
>
> > # PostgreSQL's Database Directory
> > PGDATA=/var/lib/postgresql/data
> >
> > Is this all you have in the postgresql.conf file??? That file is
> > usually full with settings(most of them optional) but still...
> > Are u sure?
> >
> > Andy.
> >
> > ----- Original Message ----- From: "guo weidong" <gwd1122331@yahoo.com>
> > To: <pgsql-admin@postgresql.org>
> > Sent: Wednesday, July 20, 2005 6:30 AM
> > Subject: [ADMIN] can not start the postgresql, i use gentoo
> >
> >
> >> I can not run start the postgresql service, and spent
> >> several days can not solve the problem. thanks for
> >> anyone who can help me .
> >> :oops: :oops: :oops: :oops: :oops:
> >> /etc/init.d/postgresql start
> >> * Starting PostgreSQL ...
> >> * Please see log file:
> >> /var/lib/postgresql/data/postgresql.log [ !! ]
> >>
> >> and my postgresql.log is
> >>
> >> FATAL: syntax error in file
> >> "/var/lib/postgresql/data/postgresql.conf" line 2,
> >> near token "/"
> >>
> >> I dont'n know what is wrong with the postgresql.conf
> >>
> >> Here is the config file
> >> postgresql.conf
> >>
> >> # PostgreSQL's Database Directory
> >> PGDATA=/var/lib/postgresql/data
> >>
> >> # Logfile path: (NOTE: This must be uid/gid owned by
> >> the value of $PGUSER!)
> >> PGLOG=/var/lib/postgresql/data/postgresql.log
> >>
> >> # Run the PostgreSQL user as:
> >> PGUSER=postgres
> >>
> >> # Extra options to run postmaster with.
> >> # If you want to enable TCP/IP for PostgreSQL, add -i
> >> to the following:
> >> PGOPTS="-N 1024 -B 2048 -i"
> >>
> >> #tcpip_socket = true
> >>
> >>
> >>
> >> ____________________________________________________
> >> Start your day with Yahoo! - make it your home page
> >> http://www.yahoo.com/r/hs
> >>
> >>
> >> ---------------------------(end of
> broadcast)---------------------------
> >> TIP 4: Have you searched our list archives?
> >>
> >> http://archives.postgresql.org
> >>
> >>
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-07-20 21:58 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-20 03:30 can not start the postgresql, i use gentoo guo weidong <gwd1122331@yahoo.com>
2005-07-20 06:09 ` Peter Eisentraut <peter_e@gmx.net>
2005-07-20 07:16 ` Andy <frum@ar-sd.net>
2005-07-20 07:55 ` Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
2005-07-20 21:58 ` Guido Barosio <gbarosio@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox