the machine that i'm using right now is goin to die very soon. So i was trying to restore it in another machine but before that I have to install postgres in this new machine.
I installed postgres successfully, created a DB cluster using initdb comand after creating a user account that would use postgres and made it the owned of the location where DB was initialized.
Then I started my postgres service using
pg_ctl start -D /usr/local/pgsql/jsbali
That was the very first time i started it and it did not give me any errors.
After that I created a new DB server using PGAdmin3 and the server was created successfully.
When i tried connecting to this server, i gave me an error Ident Authentication failed and wanted me to do appropriate changes in pg_hba.conf file
However, in pg_hba.conf file, i have the settings for the trusted connection.
pg_hba.conf and postgresql.conf files i copied from my old Db server and overwrote on the ones that were created as a result of initidb in the new database.
Right after this point, pg_ctl start, stop and reload doesn't work at all.
There was some problem with postmaster.pid file, so i just removed it.
The last error that i got after tryin to start postgres is :
could not bind IPv6 socket: Address already in use.
HINT: Is another postmaster already running on port 5432? If not , wait a few seconds and retry.
LOG: could not bind IPv$ socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not , wait a few seconds and retry.
WARNING: could not create listen socket for "*"
FATAL: could not create any TCP/IP sockets
On 10/11/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"J S B" <jsbali@xxxxxxxxx> writes:
> FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
> denied
> Can you please tell me what is this all about?
It looks to me like you have, or had, another postmaster running under a
different userid. Perhaps you should back up to the beginning and tell
us what you've been doing with this installation.
regards, tom lane
