| From: | "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de> |
|---|---|
| To: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
| Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: postgresql.conf |
| Date: | 2015-11-19 15:18:02 |
| Message-ID: | trinity-8f12ca0f-db14-4a36-af86-e81301aeacd8-1447946282086@3capp-gmx-bs59 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> Gesendet: Donnerstag, 19. November 2015 um 15:11 Uhr
> Von: "Campbell, Lance" <lance(at)illinois(dot)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';
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ferrell, Denise D CTR NSWCDD, H11 | 2015-11-19 15:20:59 | Re: [Non-DoD Source] Re: Inserting .png file into bytea column |
| Previous Message | Craig James | 2015-11-19 15:09:24 | Re: Inserting .png file into bytea column |