[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

postgresql database file names



I am trying to determine how to correlate the file system file names to a database in /var/lib/postgres/data/base with the database names used in postgresql

 

The file system names are:

 

drwx------  2 postgres postgres  4096 Oct 29 08:41 1

drwx------  2 postgres postgres  4096 Oct 24  2005 17141

drwx------  3 postgres postgres 16384 Oct 29 07:00 19333

drwx------  3 postgres postgres 20480 Oct 29 07:03 3245791

drwx------  3 postgres postgres 24576 Oct 29 06:03 4859886

drwx------  3 postgres postgres  4096 Oct 29 07:01 6983994

 

but the database names are in alpha characters, such as template0, template1 etc.

 

Is there a way to determine which directory goes to which database?

 

Thanks

 

Tony


Reply to: