On Thursday 09 March 2017 16:37:28 you wrote: > 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 Thanks Adrian. I had figured that out eventually, and found the missing files where you said they were. Appreciate the info on how to get the configuration values. A lot seems to have changed since I started using Postgresql and I guess I should really read up on how things work now and not in 2008! Regards, John -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
