X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9FF10529A6 for ; Thu, 30 Jun 2005 07:43:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85002-09 for ; Thu, 30 Jun 2005 10:43:24 +0000 (GMT) Received: from titan.ecommit.de (titan.ecommit.de [195.145.58.245]) by svr1.postgresql.org (Postfix) with ESMTP id 4A0AA529EB for ; Thu, 30 Jun 2005 07:43:22 -0300 (ADT) Received: from titan.ecommit.de (localhost [127.0.0.1]) by titan.ecommit.de (8.12.6/8.12.6/SuSE Linux 0.6) with ESMTP id j5UAhN0F022995; Thu, 30 Jun 2005 12:43:23 +0200 Received: from titan.ecommit.de (root@localhost) by titan.ecommit.de (8.12.6/8.12.6/Submit) with ESMTP id j5UAhNDo022994; Thu, 30 Jun 2005 12:43:23 +0200 Received: from fandelm.ecommit.de (fandelm.tc.de 192.168.252.51) by titan.ecommit.de (Scalix SMTP Relay 9.0.0.26) via ESMTP; Thu, 30 Jun 2005 12:43:21 +0200 (CEST) Date: Thu, 30 Jun 2005 12:41:49 +0200 From: "Martin Fandel" To: jehan-free Cc: pgsql-admin@postgresql.org Message-ID: <1120128109.18693.43.camel@fandelm.ecommit.de> In-Reply-To: <42C3D00E.1010106@free.fr> References: References: <1120113173.18693.39.camel@fandelm.ecommit.de> References: <42C3D00E.1010106@free.fr> Subject: Re: restore database from bare files x-scalix-Hops: 1 X-Mailer: Evolution 2.0.1 Mime-Version: 1.0 Content-Type: text/plain Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.034 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/286 X-Sequence-Number: 18041 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 > > > > >