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 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/ > pgsql/data/base/16980/ > so I made the assumption that 1 is a database (probably the test initial > database ?), 16975 is an other one and 16980 a tird one ! How can I find > the map from these numbers to database name ? > thanks > Martin Fandel wrote: > > >Hi > > > >Maybe you must reset the WAL's > >( http://www.postgresql.org/docs/7.3/interactive/app-pgresetxlog.html ) > >after restoring from tarball if postgres doesn't start. > > > >Am Donnerstag, den 30.06.2005, 07:34 +0200 schrieb jehan: > > > > > >>So I must one way or another run a 7.3, restore the file from the > >>tarball as is (just put them back to /var/lib/pgsql), the databases > >>should be running correctly then (?), then pg_dump it , upgrade to 7.4 > >>and restore from the pg_dump . > >>before running in all this (and I still don't know how I will be able to > >>get a 7.3 on RHEL4 ... ?) is that the correct procedure ? > >>thanks > >> > >> > > > >yes, this is the correct way :). > > > >Martin > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 9: In versions below 8.0, the planner will ignore your desire to > > choose an index scan if your joining column's datatypes do not > > match > > > > >
