Postgresql Recovery from the file system.

[Ayaz Ahmed]

Dear community

I am using Ubuntu 21.04 and Postgresql 13.

Unfortunately today postgres's service has been stopped running. And I don't have any backup.

I have data only in file system /var/lib/postgresql/13/main can I recover my database? If yes please let me know I will be thankful to you.

When I try to connect postgresql through pgadmin system giving below message.

psql: error: could not connect to server: No such file or directory

        Is the server running locally and accepting

        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Is there any solution for this disaster?

[Martin Schönbeck]

Hi,

what error messages does postgresql show when you start the service again? (service postgresql status)

Regards,

Martin

[Heng Sin Low]

you should ask in postgresql user forum instead, should get more help over there.

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/CAMtCXyW2PHcZ2nFCMWLBo3bW7rWoOXFcf-%2BXqLE1E71VtkgFAQ%40mail.gmail.com.

[Ricardo Alexsander Santana]

If you still have the data folder, you could try to recover using docker:

1. Back up your data folder and copy to your computer

2. Launch a docker container with same postgres version of your broken server, pointing the data folder to your recovered data folder, something like this:

docker run -d \
--name my-postgres \
-e POSTGRES_PASSWORD=mypassword \
-e PGDATA=/var/lib/postgresql/data/pgdata \
-v /my/recovered/postgres/data:/var/lib/postgresql/data \
postgres:13-bullseye

3. Perform a pg_dump:

docker exec my-postgres pg_dump -U adempiere -d idempiere > ExpDat.dmp

Att.

--
Ricardo Alexsander Santana
ralex...@gmail.com

--

[Ayaz Ahmed]

attached status png

--

You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/159800a3-0b48-476a-b282-47b6a46174can%40googlegroups.com.

--

Ayaz Ahmed
Cell: +92 345 3937793
http://ayaz-ahmed.blogspot.com/

[Martin Schönbeck]

Hi,

Ayaz Ahmed schrieb am Mittwoch, 13. Juli 2022 um 07:41:02 UTC+2:

attached status png

if not already done, try a restart

Regards,

Martin

[Ayaz Ahmed]

I have tried many times but could not recover.

[Dirk Niemeyer]

On command line you can switch to user postgres and run psql.
Then see if your idempiere database still exists and has content.

Regards

Dirk Niemeyer

Am 13.07.22 um 10:49 schrieb Ayaz Ahmed:

[Flo Boj]

Hi !

Also

please run pg-dump every day in future .

I crontabed that with cronie every day at 2 minutes past 5 in the morning :  

2 5 * * *  pg_dump -U <username> <databasename>   > /whereever.sql

Best Regards

Florian

[Vladislav Khrenov]

The better way to use datetime in the backup file name. It's give you a chance to recover not only last backup, where you can got data errors and user mistakes.

пт, 15 июл. 2022 г. в 14:25, Flo Boj <flob...@gmail.com>:

--

You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/a78ee73d-cacd-4c23-93db-82c9563a6c30n%40googlegroups.com.

[Martin Schönbeck]

Hi,

siber...@gmail.com schrieb am Freitag, 15. Juli 2022 um 14:48:26 UTC+2:

The better way to use datetime in the backup file name. It's give you a chance to recover not only last backup, where you can got data errors and user mistakes.

which can be done easily by using util/RUN_DBExport.sh and perhaps adding some lines to utils/myDBcopy.sh to send the file to something externally.

Regards,

Martin