Search Postgresql Archives

Re: Unable to start postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 03/08/2017 10:12 AM, John Iliffe wrote:
I think you may have hit it but I'm even more confused now.

I looked at the running Postgesql on the current server and there is a 5th
sub-directory called /data.  That is on the same level as the /bin, /share,
etc.  In this new installation it is not present and neither is the
postgresql.conf file, nor are the hba files that restrict logins.

So, my question:  is this a change between version 9.2.1 and 9.6.2 and if
so where is the postgresql.conf file (I can't find it on a scan but it could
be renamed I suppose)?

Or, is there something wrong with the installation?  I went by the
successful conclusion message from make install and assumed everything
would be as expected in the directories.

Any ideas as to what may have happened?

Just realized this was an old post that just came through. I also realized that my explanation of where the *.conf files are was specific to a source default install. Package installs may locate them elsewhere. In that case as a Postgres superuser(postgres for example) do:

test=# select * from pg_settings where sourcefile is not null;
 .....

name            | DateStyle
setting         | ISO, MDY
unit            | NULL
category        | Client Connection Defaults / Locale and Formatting
short_desc      | Sets the display format for date and time values.
extra_desc      | Also controls interpretation of ambiguous date inputs.
context         | user
vartype         | string
source          | configuration file
min_val         | NULL
max_val         | NULL
enumvals        | NULL
boot_val        | ISO, MDY
reset_val       | ISO, MDY
sourcefile      | /usr/local/pgsql/data/postgresql.conf
sourceline      | 538
pending_restart | f
 .....

And look for the sourcefile location.


John



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux