Re: [ADMIN] accidentally deleted data directory
Thara Vadakkeveedu wrote: ps –edf shows no postgres processes: -bash-4.1$ ps -edf | grep postgres root 6412 6249 0 18:22 pts/000:00:00 su - postgres postgres 6413 6412 0 18:22 pts/000:00:00 -bash postgres 6465 6413 1 18:27 pts/000:00:00 ps -edf postgres 6466 6413 0 18:27 pts/000:00:00 grep postgres Ok. Ran the following command as postgres user -bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data pgstartup.log is empty -bash-4.1$ pwd /var/lib/pgsql/9.2 -bash-4.1$ ls backups data logfile pgstartup.log -bash-4.1$ ls -al total 20 drwx--. 4 postgres postgres 4096 Sep 23 18:21 . drwx--. 3 postgres postgres 4096 Sep 23 18:18 .. drwx--. 2 postgres postgres 4096 Apr 1 19:41 backups drwx--. 15 postgres postgres 4096 Sep 23 18:28 data -rw---. 1 postgres postgres 409 Sep 22 11:44 logfile -rw--- 1 postgres postgres0 Sep 23 18:20 pgstartup.log -bash-4.1$ Is there something else I can try? Yes. Look how logging is configured in /var/lib/pgsql/9.2/data/postgresql.conf (parameters log_destination, logging_collector, log_directory, log_filename). Find the log file and see what is in there. I don’t have any data to restore. This is an installation which is only a couple of weeks old. I can uninstall and reinstall if that is easier. I don't know if that would solve the problem. Where can I find the uninstaller ? How did you install PostgreSQL? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] accidentally deleted data directory
Here are the settings in the postgresql.conf file: I remember turning on logging to troubleshoot a performance issue log_destination = 'stderr' logging_collector = on log_directory = 'pg_log' #log_filename = 'postgresql-%a.log' log_truncate_on_rotation=on log_rotation_age = 1d log_rotation_size = 0 I installed postges from an rpm file (pgdg-redhat92-9.2-7.noarch.rpm) using yum install. Thanks, thara. From: Albe Laurenz laurenz.a...@wien.gv.at To: Thara Vadakkeveedu thar...@yahoo.com; pgsql-admin@postgresql.org pgsql-admin@postgresql.org Sent: Tuesday, September 24, 2013 6:41 AM Subject: Re: [ADMIN] accidentally deleted data directory Thara Vadakkeveedu wrote: ps –edf shows no postgres processes: -bash-4.1$ ps -edf | grep postgres root 6412 6249 0 18:22 pts/0 00:00:00 su - postgres postgres 6413 6412 0 18:22 pts/0 00:00:00 -bash postgres 6465 6413 1 18:27 pts/0 00:00:00 ps -edf postgres 6466 6413 0 18:27 pts/0 00:00:00 grep postgres Ok. Ran the following command as postgres user -bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data pgstartup.log is empty -bash-4.1$ pwd /var/lib/pgsql/9.2 -bash-4.1$ ls backups data logfile pgstartup.log -bash-4.1$ ls -al total 20 drwx--. 4 postgres postgres 4096 Sep 23 18:21 . drwx--. 3 postgres postgres 4096 Sep 23 18:18 .. drwx--. 2 postgres postgres 4096 Apr 1 19:41 backups drwx--. 15 postgres postgres 4096 Sep 23 18:28 data -rw---. 1 postgres postgres 409 Sep 22 11:44 logfile -rw--- 1 postgres postgres 0 Sep 23 18:20 pgstartup.log -bash-4.1$ Is there something else I can try? Yes. Look how logging is configured in /var/lib/pgsql/9.2/data/postgresql.conf (parameters log_destination, logging_collector, log_directory, log_filename). Find the log file and see what is in there. I don’t have any data to restore. This is an installation which is only a couple of weeks old. I can uninstall and reinstall if that is easier. I don't know if that would solve the problem. Where can I find the uninstaller ? How did you install PostgreSQL? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] accidentally deleted data directory
This is what I find in pg_log/postgresql-Mon.log file (contents relate to my attempts to start postgres yesterday) LOG: database system was shut down at 2013-09-22 12:20:51 EDT LOG: invalid magic number in log file 0, segment 39, offset 0 LOG: invalid primary checkpoint record LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 2361) was terminated by signal 6: Aborted LOG: aborting startup due to startup process failure LOG: database system was shut down at 2013-09-22 12:20:51 EDT LOG: invalid magic number in log file 0, segment 39, offset 0 LOG: invalid primary checkpoint record LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 6323) was terminated by signal 6: Aborted LOG: aborting startup due to startup process failure LOG: database system was shut down at 2013-09-22 12:20:51 EDT LOG: invalid magic number in log file 0, segment 39, offset 0 LOG: invalid primary checkpoint record LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 6346) was terminated by signal 6: Aborted LOG: aborting startup due to startup process failure LOG: database system was shut down at 2013-09-22 12:20:51 EDT LOG: invalid magic number in log file 0, segment 39, offset 0 postgresql-Mon.log 49L, 2709C thanks thara. From: Thara Vadakkeveedu thar...@yahoo.com To: Albe Laurenz laurenz.a...@wien.gv.at; pgsql-admin@postgresql.org pgsql-admin@postgresql.org Sent: Tuesday, September 24, 2013 9:47 AM Subject: Re: [ADMIN] accidentally deleted data directory Here are the settings in the postgresql.conf file: I remember turning on logging to troubleshoot a performance issue log_destination = 'stderr' logging_collector = on log_directory = 'pg_log' #log_filename = 'postgresql-%a.log' log_truncate_on_rotation=on log_rotation_age = 1d log_rotation_size = 0 I installed postges from an rpm file (pgdg-redhat92-9.2-7.noarch.rpm) using yum install. Thanks, thara. From: Albe Laurenz laurenz.a...@wien.gv.at To: Thara Vadakkeveedu thar...@yahoo.com; pgsql-admin@postgresql.org pgsql-admin@postgresql.org Sent: Tuesday, September 24, 2013 6:41 AM Subject: Re: [ADMIN] accidentally deleted data directory Thara Vadakkeveedu wrote: ps –edf shows no postgres processes: -bash-4.1$ ps -edf | grep postgres root 6412 6249 0 18:22 pts/0 00:00:00 su - postgres postgres 6413 6412 0 18:22 pts/0 00:00:00 -bash postgres 6465 6413 1 18:27 pts/0 00:00:00 ps -edf postgres 6466 6413 0 18:27 pts/0 00:00:00 grep postgres Ok. Ran the following command as postgres user -bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data pgstartup.log is empty -bash-4.1$ pwd /var/lib/pgsql/9.2 -bash-4.1$ ls backups data logfile pgstartup.log -bash-4.1$ ls -al total 20 drwx--. 4 postgres postgres 4096 Sep 23 18:21 . drwx--. 3 postgres postgres 4096 Sep 23 18:18 .. drwx--. 2 postgres postgres 4096 Apr 1 19:41 backups drwx--. 15 postgres postgres 4096 Sep 23 18:28 data -rw---. 1 postgres postgres 409 Sep 22 11:44 logfile -rw--- 1 postgres postgres 0 Sep 23 18:20 pgstartup.log -bash-4.1$ Is there something else I can try? Yes. Look how logging is configured in /var/lib/pgsql/9.2/data/postgresql.conf (parameters log_destination, logging_collector, log_directory, log_filename). Find the log file and see what is in there. I don’t have any data to restore. This is an installation which is only a couple of weeks old. I can uninstall and reinstall if that is easier. I don't know if that would solve the problem. Where can I find the uninstaller ? How did you install PostgreSQL? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] accidentally deleted data directory
Thank you! I deleted data directory again and then ran initdb. This time service started successfully. TG From: Albe Laurenz laurenz.a...@wien.gv.at To: Thara Vadakkeveedu thar...@yahoo.com; pgsql-admin@postgresql.org pgsql-admin@postgresql.org Sent: Tuesday, September 24, 2013 10:11 AM Subject: Re: [ADMIN] accidentally deleted data directory Thara Vadakkeveedu wrote: Do I need to run pg_resetxlog to fix the corrupted pg_control file issue? No, since you don't mind starting afresh, just delete the data directory and run initdb. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] accidentally deleted data directory
Thara Vadakkeveedu wrote: I am new to postgresql. I have postgresql 9.2 installed on Red hat linux 6.4 I accidentally deleted data directory this morning (/var/lib/postgresql/9.2/data) I tried to start posgresql 9.2 service service postgresql9.2 start I got a amessage to initialize the db first. so I ran service postgresql-9.2 initdb this was successful then i tried service postgresql-9.2 start this failed. pgstartup.log indicated I can start the database server using: /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data or /usr/pgsql-9.2/bin/pg_ctl -D /var/lib/pgsql/9.2/data -l logfile start However I am unable to start database as root That is the only account I use on this server. I tried su - postgres and then from the bash shell i tried to run these commands (tried one at a time) but it said address in use there are no processes running on 5432. How can I start postgres service? See if there are processes running for user postgres that look like database processes and kill them. Then try again. What exactly is the error message? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] accidentally deleted data directory
If pgstartup.log is empty that points at an issue with the configuration file. From memory, when you do an initdb it recreates the configuration files in the /var/lib/pg... directory. I would look at the main control file and the pg_hba.conf and try to start the database passing it the name of the main conf file as a parameter (as well as the database directory). Cheers, Cliff On Tue, Sep 24, 2013 at 10:36 AM, Thara Vadakkeveedu thar...@yahoo.comwrote: See if there are processes running for user postgres that look like database processes and kill them. Then try again. What exactly is the error message? Yours, Laurenz Albe Hi ps –edf shows no postgres processes: -bash-4.1$ ps -edf | grep postgres root 6412 6249 0 18:22 pts/000:00:00 su - postgres postgres 6413 6412 0 18:22 pts/000:00:00 -bash postgres 6465 6413 1 18:27 pts/000:00:00 ps -edf postgres 6466 6413 0 18:27 pts/000:00:00 grep postgres Ran the following command as postgres user -bash-4.1$ /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data -bash-4.1$ pgstartup.log is empty -bash-4.1$ pwd /var/lib/pgsql/9.2 -bash-4.1$ ls backups data logfile pgstartup.log -bash-4.1$ ls -al total 20 drwx--. 4 postgres postgres 4096 Sep 23 18:21 . drwx--. 3 postgres postgres 4096 Sep 23 18:18 .. drwx--. 2 postgres postgres 4096 Apr 1 19:41 backups drwx--. 15 postgres postgres 4096 Sep 23 18:28 data -rw---. 1 postgres postgres 409 Sep 22 11:44 logfile -rw--- 1 postgres postgres0 Sep 23 18:20 pgstartup.log -bash-4.1$ Is there something else I can try? I don’t have any data to restore. This is an installation which is only a couple of weeks old. I can uninstall and reinstall if that is easier. Where can I find the uninstaller ? Thanks Thara.