I deleted postmaster.pid file and got rid of the previous error.
Now its a new error which say something as follows after i try starting my postgres server usring pg_ctl start -D /usr/local/pgsql/jsbali :-
postmaster starting
LOG: could not bind IPv4 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
Can you please tell me what is this all about?
Jas
On 10/11/06, J S B <jsbali@gmail.com> wrote: i never touched it. when i opened it to check the stuff inside, found it empty.
What should i do now?
On Wed, Oct 11, 2006 at 02:50:59PM -0400, J S B wrote:
> I'm trying to start my postgres server using
>
> #> pg_ctl start -D /usr/local/pgsql/abc
>
> and get an error like:
>
> invalid data in PID file "/usr/local/pgsql/abc/postmaster.pid"
>
> can anyone comment whats wrong.
>
> My postmaster.pid file is empty at the time when i run this command.
I think the fact that it's empty may be what's wrong. It should have
something in it.
How did you manage to get into that state?
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org > http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFFLT5uIB7bNG8LQkwRArQGAJkBQ3lvZwdoQ1MRXIJVGCMBA3NoKwCeLrGj
EUBt6BZ7QOgxzrf89BEYpyI=
=xQpd
-----END PGP SIGNATURE-----