pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guido Barosio <gbarosio@gmail.com>
To: Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
Cc: Andy <frum@ar-sd.net>
Cc: guo weidong <gwd1122331@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: can not start the postgresql, i use gentoo
Date: Wed, 20 Jul 2005 22:58:06 +0100
Message-ID: <f7f6b4c705072014584e515506@mail.gmail.com> (raw)
In-Reply-To: <42DE0386.5090904@mail.jct.ac.il>
References: <20050720033010.43842.qmail@web34111.mail.mud.yahoo.com>
	<004c01c58cfb$0b996790$0b00a8c0@forge>
	<42DE0386.5090904@mail.jct.ac.il>

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.

view thread (5+ messages)

Message-ID: <f7f6b4c705072014584e515506@mail.gmail.com>
Permalink:  ../f7f6b4c705072014584e515506@mail.gmail.com/
Also on:    postgresql.org/message-id/f7f6b4c705072014584e515506@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gbarosio@gmail.com, tsurkin@mail.jct.ac.il, frum@ar-sd.net, gwd1122331@yahoo.com
  Subject: Re: can not start the postgresql, i use gentoo
  In-Reply-To: <f7f6b4c705072014584e515506@mail.gmail.com>
  References: <20050720033010.43842.qmail@web34111.mail.mud.yahoo.com> <004c01c58cfb$0b996790$0b00a8c0@forge> <42DE0386.5090904@mail.jct.ac.il> <f7f6b4c705072014584e515506@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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