Hi any one help me out in this i have pgsql installed on my Linux server.The directory path for database is /var/database. The following is directory structure of my server.


[root@localhost ~]# cd /var/database/
[root@localhost database]# ls
lost+found pgsql8.3
[root@localhost database]# cd pgsql8.3/
[root@localhost pgsql8.3]# ls
data log
[root@localhost pgsql8.3]# cd data/
[root@localhost data]# ls
base pg_hba.conf pg_log pg_tblspc pg_xlog postmaster.opts
global pg_hba.conf~ pg_multixact pg_twophase postgresql.conf postmaster.pid
pg_clog pg_ident.conf pg_subtrans PG_VERSION postgresql.conf~
[root@localhost data]# cd base
[root@localhost base]# pwd
/var/database/pgsql8.3/data/base
[root@localhost base]# ls
1 11510 11511 155661 163853 16396 45320 74230 pgsql_tmp
[root@localhost base]#

Based on the numbers shown above i want to identify to which database it represents.

My database structure is shown below.
[ppppp@localhost ~]$ psql -l
List of databases
Name | Owner | Encoding
-----------------+----------+-----------
ESMdatabase | ppppp | UTF8
porting_ppppp | ppppp | SQL_ASCII
porting_pppppui | ppppp | SQL_ASCII
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
training | ppppp | SQL_ASCII
training_main | ppppp | SQL_ASCII
(8 rows)

please help me out. Thanks in advance.

How do you think we'll be able to identify it any better than you, based on what you posted? Also, you've never posted follow-ups, thanks, or given any indication you've even read the replies in your other threads that you've opened here.

There are hints you can find in the Postgres docs:
http://www.postgresql.org/

And have you checked the conf files, to see if they have any paths in them? You could also shut down the engine, rename one of the files, restart it, and see which databases don't come back, and identify them that way.

1 members found this post helpful.