Re: Unable to start postgresql

On 03/07/2017 08:17 PM, John Iliffe wrote:
> I was unable to get postgres started so I did a very basic compile/install
> to test it. The configuration line was:
>
> ./configure --prefix=/usr/postgres-9.6.2
>
> --------------------------------
> Then I ran make which completed as expected:
>
> make[1]: Leaving directory '/tmp/postgresql-9.6.2/config'
> All of PostgreSQL successfully made. Ready to install.
>
> --------------------------------------
> Then make check
>
> make check
>
> =======================
> All 167 tests passed.
> =======================
>
> make[1]: Leaving directory '/tmp/postgresql-9.6.2/src/test/regress'
> ----------------------------------------
>
> Then make install as user root because of directory permissions. I have
> the expected files in /usr/postgres_9.6.2
>
> Now, running as user postgres I try and start as stated in the manual
>
> postgres -D /usr/pgsql_tablespaces
>
> initdb has already been run and the directory pgsql_tablespaces has a
> number of files as expected. As yet no database has been defined because
> psql won't start.

Just to be clear you installed in:

/usr/postgres-9.6.2

but created the data directory in:

Also above you say:

"I was unable to get postgres started so I did a very basic
compile/install to test it. "

To me that implies there is another instance of Postgres on the system,
is that the case?

If not could you explain what you meant?

>
> The result is:
> [postgres(at)prod04 postgresql-9.6.2]$ postgres -D /usr/pgsql_tablespaces
> LOG: could not bind IPv4 socket: Cannot assign requested address
> HINT: Is another postmaster already running on port 5432? If not, wait a
> few seconds and retry.
> LOG: database system was shut down at 2017-03-07 22:22:57 EST
> LOG: MultiXact member wraparound protections are now enabled
> LOG: database system is ready to accept connections
> LOG: autovacuum launcher started
>
> Same results if I use pg_ctl to start the process.
>
> I checked with lsof and there is no process bound to socket 5432. There is
> no entry in /var/run for a socket related to postgresql.
>
> I thought it might be a security issue so I put SELinux in permissive mode
> but the result is the same. The SELinux journal does not show any warnings
> on this process.
>
> [root(at)prod04 postgresql-9.6.2]# sestatus
> SELinux status: enabled
> SELinuxfs mount: /sys/fs/selinux
> SELinux root directory: /etc/selinux
> Loaded policy name: targeted
> Current mode: permissive <------permissive mode**
> Mode from config file: permissive
> Policy MLS status: enabled
> Policy deny_unknown status: allowed
> Max kernel policy version: 30
> -----------------------------------------------------------------
>
> One thing that I haven't been able to find any the log files. Where are they
> normally stored?
>
> So, any ideas as to where to go next to debug this would be appreciated!
> This is a brand new server that I am trying to configure so I have a fair
> amount of security clearance to chase things.
>
> Thanks in advance.
>
> John
> =====================================
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com