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/
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