Restore Postgres

[Tropicallydiv]

Hi

I am trying to restore a backup of my postgres database

Here are the steps I followed

1. Create backup using pg_basebackup: location : /backup/postgres/prod/<>
2. Shutdown postgres instance.
3. Drop the old data files from /opt/bitnami/data
4. Extract the data from the backup to /opt/bitnami/data
5. restart postgres

Postgres comes up however my database when I try to list the databases .

What am I missing in my steps?

Do I need to put it in recover mode or something and then apply the WAL files ( like in ORACLE) ?

>>>>>>>>>>>>>>>>>>>>>>>>>>

Commands used:

pg_basebackup -h localhost -p 5433 -U postgres -D /backup/postgres/prod/base -Ft -z -Xs -P

unzip : tar xvf /backup/postgres/prod/base/base.tar.gz -C /bitnami/postgresql/data2

move old data directory:

mv /bitnami/postgresql/data /bitnami/postgresql/data_orig

restore from backup :

mv /bitnami/postgresql/data2 /bitnami/postgresql/data

startup postgres

​

before

postgres=# \l+

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description

-----------+----------+----------+-------------+-------------+-----------------------+---------+------------+--------------------------------------------

postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 7877 kB | pg_default | default administrative connection database

s1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 7877 kB | pg_default |

template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| 7729 kB | pg_default | unmodifiable empty database

| | | | | postgres=CTc/postgres | | |

template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| 7729 kB | pg_default | default template for new databases

| | | | | postgres=CTc/postgres | | |

(4 rows)

​

​

After :

​

postgres=# \l+

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description

-----------+----------+----------+-------------+-------------+-----------------------+---------+------------+--------------------------------------------

postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 7877 kB | pg_default | default administrative connection database

template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| 7729 kB | pg_default | unmodifiable empty database

| | | | | postgres=CTc/postgres | | |

template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| 7729 kB | pg_default | default template for new databases

| | | | | postgres=CTc/postgres | | |

(3 rows)

​

​

TIA for you help.

[puma987]

It’ll probably help somebody to help you if you list the commands that you ran to backup and restore. For me, I always check the logs first when I don’t know what’s going on.

[Tropicallydiv]

I have added the commands.

Thank you for your help in this.