LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-01-2011, 09:27 AM   #1
praveenhari
LQ Newbie
 
Registered: Jan 2011
Posts: 4

Rep: Reputation: 0
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.
 
Old 07-01-2011, 11:07 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,488

Rep: Reputation: 3970Reputation: 3970Reputation: 3970Reputation: 3970Reputation: 3970Reputation: 3970Reputation: 3970Reputation: 3970Reputation: 3970Reputation: 3970Reputation: 3970
Quote:
Originally Posted by praveenhari View Post
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.

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.
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
pl/pgsql help sajith Programming 1 12-16-2005 03:01 PM
Nothing after rc.pgsql in rc.M starts karlmdv Slackware 4 04-04-2005 03:44 PM
PL/pgSQL anyone? vickr1z Linux - Newbie 0 10-20-2004 12:58 AM
Pgsql or mysql? other? Raspis21 Linux - Software 13 11-14-2003 10:25 PM
Dates in PL/PGSQL anisbet Linux - General 0 11-19-2001 10:16 AM


All times are GMT -5. The time now is 10:14 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration