Extract current database structure

Hi all,

am new here and PostgreSQL is completely new land for me! So pleas be patient.

We have an external development team building a web application base on python and PostgreSQL on a centos box for a current project.

I was wondering if there is a way - preferably without pgdmin - to extract the current database structure / even convert it into and access format or so if you do not have a username / password for the database.

So to see all tables, files and relation ships.

I have full root access to the box!

Hope someone can help me out here please
Tnx a mill

So you want to get the database objects from a database to which you cannot connect? No that's not possible

You can import the whole information schema to MsAccess and then distribute that.
Of course a proper reverse engineering of the database into a Powerdesigner or ErWin file would be better IMHO

Hi all,

Tnx so much for ur replies.

I think I manged to get access to the database from the root user with psql -U postgres

if I then do a \l I see a list of existing databases and their owners

I also can connect to any database with \c and then \d gives me a list of tables, indexes, sequences and views!



Just wanted to make sure now that I am doing the right thing: want to dump the databases.

pg_dumpall -U postgres | gzip -c > /mnt/share/<name>.gz

or for each individual database

pg_dump -U postgres <databasename> | gzip -c > /mnt/share/<name>.gz


Will that dump all information information from all databases?

Then I also want to do a complete system dump - not sure if I should ask this here or open another post in a different forum but I see postgres .

For the complete system dump I use the following command from / :

tar lcf - . | gzip -c > /data/completesysdump220420081300-1.tar.gz

I get then a couple of ignored messages - is that something to get worry about?

tar: Semantics of -l option will change in the future releases.
tar: Please use --one-file-system option instead.
tar: ./tmp/.font-unix/fs7100: socket ignored
tar: ./tmp/.s.PGSQL.5432: socket ignored
tar: ./home/mdb_manager/nohup.out: file changed as we read it
tar: ./var/run/setrans/.setrans-unix: socket ignored
tar: ./var/run/audit_events: socket ignored
tar: ./var/run/avahi-daemon/socket: socket ignored
tar: ./var/run/sdp: socket ignored
tar: ./var/run/acpid.socket: socket ignored
tar: ./var/run/dbus/system_bus_socket: socket ignored
tar: ./var/run/cups/cups.sock: socket ignored
tar: ./var/run/setroubleshoot/setroubleshoot_server: socket ignored
tar: ./var/run/pcscd.comm: socket ignored

Tnx a mill again in advance for help / suggestions