Re: [GENERAL] Unable to start postgresql
От | Melvin Davidson |
---|---|
Тема | Re: [GENERAL] Unable to start postgresql |
Дата | |
Msg-id | CANu8Fizt_rremzxpRU+AL5J-Ue6w0caQ-kGZjpzDvkE8w0yswg@mail.gmail.com обсуждение исходный текст |
Ответ на | [GENERAL] Unable to start postgresql (John Iliffe <john.iliffe@iliffe.ca>) |
Ответы |
Re: [GENERAL] Unable to start postgresql
(John Iliffe <john.iliffe@iliffe.ca>)
|
Список | pgsql-general |
On Tue, Mar 7, 2017 at 11:17 PM, John Iliffe <john.iliffe@iliffe.ca> 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.
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
This is very suspicicious.
>LOG: could not bind IPv4 socket: Cannot assign requested address
>HINT: Is another postmaster already running on port 5432? If not, wait a
f>ew seconds and retry.
>LOG: could not bind IPv4 socket: Cannot assign requested address
>HINT: Is another postmaster already running on port 5432? If not, wait a
f>ew seconds and retry.
So check to see if the file "postmaster.pid" exists.
If it does, and postgres is NOT running, just delet or rename it and try to start.--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления:
Предыдущее
От: Panagiotis AtmatzidisДата:
Сообщение: Re: [GENERAL] Copy database to another host without data from specific tables
Следующее
От: Yogesh SharmaДата:
Сообщение: [GENERAL] Request to confirm which command is use for exclusive operation