Postgresql restore Restore data from tar file

I have a tar archive with full backup of my CentOS filesystem with pg9PostgreSQL 9.1 installed.

How can I restore one database from it?

If I can only restore a full database cluster, how can I do that? Just copy-paste all the files?

Post Reopened by Hannah Vernon♦, mustaccio, McNets, RDFozz, Paul White♦

occurred Nov 22, 2018 at 2:38

Post Closed as "Duplicate" by Paul White♦, RolandoMySQLDBA, Mark Storey-Smith, Kin Shah, ypercubeᵀᴹ

occurred Apr 16, 2014 at 10:44

Post Migrated Here from stackoverflow.com (revisions)

occurred Mar 15, 2014 at 1:14

Source Link

asked Mar 14, 2014 at 11:46

Postgresql restore data from file

I have a tar archive with full backup of my CentOS filesystem with pg9.1 installed. How can I restore one database from it?