Search Postgresql Archives

Re: Unable to start postgresql

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

 



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



[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