Обсуждение: just a quick one ...
i have 2 postgresql boxes, one live and one for dev. the dev box has postgresql 7.2 compiled from source and ps auxf gets me a postmaster process and then the db parameters (-i -B 512 etc). the live box has 7.2 from deb packages and i have edited postgresql.conf to give the same start parameters as the dev box but on ps auxf i don't get any extra info ... is there a way i check to see if postgresql started with the options i want and not the defaults ? performance seems ok but i'm worried that the live box may not have started properly .... live box: postgres 320 0.0 0.3 16784 1780 ? S Jul15 0:13 /usr/lib/postgresql/bin/postmaster postgres 322 0.0 0.5 17776 2748 ? S Jul15 0:02 \_ postgres: stats buffer process postgres 323 0.0 0.3 16856 1836 ? S Jul15 0:10 \_ postgres: stats collector process thanks, Steve Brett p..s i totally agree with the previous thread that was extolling the virtues of postgresql and especially the amazing support. keep it up guys !
On Wed, 17 Jul 2002 16:50:50 +0100, Steve Brett <SBrett@e-mis.com> wrote: >is there a way i check to see if postgresql started with the options i want >and not the defaults ? # psql anydb anydb=# SHOW ALL; NOTICE: enable_seqscan is on NOTICE: enable_indexscan is on . . . Servus Manfred
On Wed, Jul 17, 2002 at 04:50:50PM +0100, Steve Brett wrote: > the live box has 7.2 from deb packages and i have edited postgresql.conf to > give the same start parameters as the dev box but on ps auxf i don't get any > extra info ... postgresql.conf specifies config options, *not* command-line parameters. So any changes there will not show up in 'ps'. You can use 'SHOW ALL;' to get a dump of your current config settings. Personally, I make all my configuration changes in postgresql.conf, and don't specify any additional arguments when starting the postmaster. Cheers, Neil -- Neil Conway <neilconway@rogers.com> PGP Key ID: DB3C29FC
test, please ignore "Steve Brett" <stevebrett@ntlworld.com> wrote in message news:ahbfd1$1gh3$1@news.hub.org... > many thanks > > Steve > > "Neil Conway" <nconway@klamath.dyndns.org> wrote in message > news:20020717162043.GA5012@klamath.dyndns.org... > > On Wed, Jul 17, 2002 at 04:50:50PM +0100, Steve Brett wrote: > > > the live box has 7.2 from deb packages and i have edited postgresql.conf > to > > > give the same start parameters as the dev box but on ps auxf i don't get > any > > > extra info ... > > > > postgresql.conf specifies config options, *not* command-line parameters. > > So any changes there will not show up in 'ps'. > > > > You can use 'SHOW ALL;' to get a dump of your current config settings. > > > > Personally, I make all my configuration changes in postgresql.conf, and > > don't specify any additional arguments when starting the postmaster. > > > > Cheers, > > > > Neil > > > > -- > > Neil Conway <neilconway@rogers.com> > > PGP Key ID: DB3C29FC > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > >
many thanks Steve "Neil Conway" <nconway@klamath.dyndns.org> wrote in message news:20020717162043.GA5012@klamath.dyndns.org... > On Wed, Jul 17, 2002 at 04:50:50PM +0100, Steve Brett wrote: > > the live box has 7.2 from deb packages and i have edited postgresql.conf to > > give the same start parameters as the dev box but on ps auxf i don't get any > > extra info ... > > postgresql.conf specifies config options, *not* command-line parameters. > So any changes there will not show up in 'ps'. > > You can use 'SHOW ALL;' to get a dump of your current config settings. > > Personally, I make all my configuration changes in postgresql.conf, and > don't specify any additional arguments when starting the postmaster. > > Cheers, > > Neil > > -- > Neil Conway <neilconway@rogers.com> > PGP Key ID: DB3C29FC > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
> "Neil Conway" <nconway@klamath.dyndns.org> wrote in message > >>Personally, I make all my configuration changes in postgresql.conf, and >>don't specify any additional arguments when starting the postmaster. >> >>Cheers, >> >>Neil >> >> Please, excuse me for stepping in. Although i read the docs, I have not found any indication on how to set the datestyle from postgresql.conf. The only way I have found is by specifying a -e parameter to postgres. Am I missing anything? Alex
On Tue, 2002-07-23 at 09:30, Alessandro Baretta wrote: > Please, excuse me for stepping in. Although i read the docs, > I have not found any indication on how to set the > datestyle from postgresql.conf. The only way I have found is > by specifying a -e parameter to postgres. > > Am I missing anything? You can also define the environment variable PGDATESTYLE; and once you are connected you can use SET DATESTYLE. In 7.3 DateStyle will be settable from postgresql.conf, but not in 7.2.1. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Finally, all of you, live in harmony with one another; be sympathetic, love as brothers, be compassionate and humble. Do not repay evil for evil or insult for insult, but with blessing, because to this you were called so that you may inherit a blessing." I Peter 3:8,9
Oliver Elphick wrote: > On Tue, 2002-07-23 at 09:30, Alessandro Baretta wrote: > >>Please, excuse me for stepping in. Although i read the docs, >> I have not found any indication on how to set the >>datestyle from postgresql.conf. The only way I have found is >>by specifying a -e parameter to postgres. >> >>Am I missing anything? > > > You can also define the environment variable PGDATESTYLE; and once you > are connected you can use SET DATESTYLE. > > In 7.3 DateStyle will be settable from postgresql.conf, but not in > 7.2.1. > Thank you very much. Alex