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. The result is: [postgres@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@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 ===================================== -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
