From: | Rob Goethals / SNP <Rob(dot)Goethals(at)snp(dot)nl> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | could not create lock file postmaster.pid: No such file or directory, but file does exist |
Date: | 2014-02-17 11:07:01 |
Message-ID: | ED8C42FD028EEC448A5E8B5D3DD4C6C601B18D10561E@2003exchange.snp.pit.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi,
This is my first post to this list, so I hope I am posting it to the correct lists. But I am really stuck and getting pretty desperate at the moment.
This weekend my database crashed while importing some Openstreetmapdata and I can't get it back to work again. It happened before and normally I would reset the WAL-dir with the pg_resetxlog command. I would loose some data but that would be all.
This time it is somehow different because he doesn't recognize any of the important files anymore. For example when I try to start Postgresql again with the command:
/usr/lib/postgresql/9.1/bin/pg_ctl -D OSM/ start
I get the following error:
FATAL: could not create lock file "postmaster.pid": No such file or directory
But when I do a ls -l on the directory I can see the file exists.
drwx------ 0 postgres postgres 0 Jan 24 10:07 backup
drwx------ 0 postgres postgres 0 Feb 14 11:10 base
drwx------ 0 postgres postgres 0 Feb 17 09:46 global
drwx------ 0 postgres postgres 0 Oct 11 10:49 pg_clog
-rwxr-xr-x 0 postgres postgres 4476 Oct 11 10:49 pg_hba.conf
-rwxr-xr-x 0 postgres postgres 1636 Oct 11 10:49 pg_ident.conf
drwx------ 0 postgres postgres 0 Feb 17 11:29 pg_log
drwx------ 0 postgres postgres 0 Oct 11 10:49 pg_multixact
drwx------ 0 postgres postgres 0 Feb 17 08:58 pg_notify
drwx------ 0 postgres postgres 0 Oct 11 10:49 pg_serial
drwx------ 0 postgres postgres 0 Feb 12 09:58 pg_stat_tmp
drwx------ 0 postgres postgres 0 Feb 14 09:01 pg_subtrans
drwx------ 0 postgres postgres 0 Oct 11 10:49 pg_tblspc
drwx------ 0 postgres postgres 0 Oct 11 10:49 pg_twophase
-rwxr-xr-x 0 postgres postgres 4 Oct 11 10:49 PG_VERSION
drwx------ 0 postgres postgres 0 Feb 14 13:37 pg_xlog
-rwxr-xr-x 0 postgres postgres 19168 Oct 11 11:41 postgresql.conf
-rwxr-xr-x 0 postgres postgres 121 Feb 17 08:57 postmaster.opts
-rwxr-xr-x 0 postgres postgres 88 Feb 17 08:58 postmaster.pid
I cannot perform any action on the postmaster.pid file. I tried cp, mv and rm, but nothing works. Is there anything I can do to make the system recognize this file again? And get my database up and running? Or is all hopelessly lost?
I have Postgresql 9.1 installed on Ubuntu 12.04.
Kind regards,
Rob.
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2014-02-17 11:42:24 | Re: could not create lock file postmaster.pid: No such file or directory, but file does exist |
Previous Message | Mohamed MANSOUR | 2014-02-16 21:38:49 | Error when installing Postgres in Windows 8.1 64bit |
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2014-02-17 11:42:24 | Re: could not create lock file postmaster.pid: No such file or directory, but file does exist |
Previous Message | Andres Freund | 2014-02-17 09:37:38 | Re: Toast and slice of toast |