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
