Regarding pgsql database
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. |
Quote:
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. |
All times are GMT -5. The time now is 02:43 PM. |