Re: [ADMIN] restore database from bare files

2005-06-30 Thread jehan-free
OK, I'am not yet at restarting postgres .. but if at get pb then I check that , thanks ! For now , How can I tell from the bare file the mapping between a database name and the number appearing in /var/lib/pgsql/base directory I have : pgsql/data/base/1/ pgsql/data/base/16975/

Re: [ADMIN] restore database from bare files

2005-06-30 Thread jehan-free
to that ? Thanks again. Martin Fandel wrote: Hi, try this: psql -t -d yourdb -c SELECT datid FROM pg_stat_database WHERE datname='yourdb'; http://www.postgresql.org/docs/8.0/static/monitoring-stats.html Greetings, Martin Am Donnerstag, den 30.06.2005, 12:57 +0200 schrieb jehan-free: OK, I'am not yet