Re: Unable to start postgresql

On Thu, Mar 9, 2017 at 10:01 PM, John Iliffe <john(dot)iliffe(at)iliffe(dot)ca> wrote:

> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

*John,*

*If you are really serious about reading up, I suggest you pick from the
books on this
url:https://www.packtpub.com/all-books?search=&offset=84&rows=&sort=
<https://www.packtpub.com/all-books?search=&offset=84&rows=&sort=>*

*Probably "PostgreSQL Administration Essentials" would be good to start
with.*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.