pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql.conf
4+ messages / 4 participants
[nested] [flat]
* postgresql.conf
@ 2006-01-09 17:07 Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
0 siblings, 1 reply; 4+ messages in thread
From: Sistemas C.M.P. @ 2006-01-09 17:07 UTC (permalink / raw)
To: pgsql-admin
I had to change the file postgresql.conf (section FILE LOCATIONS -> data_directory)because I need to point to another location.
But when I reboot the system, it indicates fail (red color) on the startup of postgresql service.
But then, it accept conections normaly and work fine with the database in the new location.
Why indicate Fail?
PD: I'm sorry. I'm From Argentina and my english is very poor
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgresql.conf
@ 2006-01-09 18:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2006-01-09 18:48 UTC (permalink / raw)
To: Sistemas C.M.P. <sistemascmp@redynet4.com.ar>; +Cc: pgsql-admin
"Sistemas C.M.P." <sistemascmp@redynet4.com.ar> writes:
> I had to change the file postgresql.conf (section FILE LOCATIONS -> =
> data_directory)because I need to point to another location.
> But when I reboot the system, it indicates fail (red color) on the =
> startup of postgresql service.
> But then, it accept conections normaly and work fine with the database =
> in the new location.
> Why indicate Fail?
I suppose your start script uses pg_ctl to start the database? pg_ctl
doesn't understand the contents of postgresql.conf so it does not know
that you've moved the data directory that way.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* postgresql.conf
@ 2015-11-19 14:11 Campbell, Lance <lance@illinois.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Campbell, Lance @ 2015-11-19 14:11 UTC (permalink / raw)
To: pgsql-admin
Postgresql 9.4.x
What is the proper way to set configuration values?
Within postresql there is a file postgresql.conf. Traditionally I go into this file directly and make configuration changes. That of course is the wrong way to do it. A person could easily have a typo and not know it. When I upgrade to 9.5 I want to make sure I am doing this the proper way.
Ideally I know you should not change postgresql.conf directly. One way of making configuration changes is using the SET command. I have no issue with that. But what is the proper way to change configuration setting that cannot be made with SET?
Thanks,
Lance Campbell
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgresql.conf
@ 2015-11-19 15:18 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
parent: Campbell, Lance <lance@illinois.edu>
0 siblings, 0 replies; 4+ messages in thread
From: Jan-Peter Seifert @ 2015-11-19 15:18 UTC (permalink / raw)
To: Campbell, Lance <lance@illinois.edu>; +Cc: pgsql-admin
> Gesendet: Donnerstag, 19. November 2015 um 15:11 Uhr
> Von: "Campbell, Lance" <lance@illinois.edu>
>
> What is the proper way to set configuration values?
Well - until 9.4 you had to edit the postgresql.conf file. As of 9.4 you can use the 'ALTER SYSTEM' command:
http://www.postgresql.org/docs/current/static/sql-altersystem.html
example:
ALTER SYSTEM SET log_min_duration_statement = '6s';
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2015-11-19 15:18 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-09 17:07 postgresql.conf Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
2006-01-09 18:48 ` Tom Lane <tgl@sss.pgh.pa.us>
2015-11-19 14:11 postgresql.conf Campbell, Lance <lance@illinois.edu>
2015-11-19 15:18 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
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