Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C63172E014F for ; Thu, 20 Mar 2008 13:04:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 53605-05-3 for ; Thu, 20 Mar 2008 13:03:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by postgresql.org (Postfix) with ESMTP id A48C12E00FC for ; Thu, 20 Mar 2008 13:03:00 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so239438ana.33 for ; Thu, 20 Mar 2008 09:02:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=kCU5yP3fRGCiG4TXXjdzByQh5QDJ7oXyqe6eVMT4P7A=; b=bPBBwSLTFqEc2RDQF6pbwpyZBEIc95ioz78a8uNZwk1Gd95gLhmTNxgRSxnS1122GN/LgguK22hrgy+X83pFoo7YwNbdI4DewEyEaytW1mjprkQQfuK5vEriXJl1JMc3Uj3PKRCv6iD5cL/9Un3xr3xtWzIzcGxXUUcSuBWvCAs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=gGrK1GJzyTh+s2dI4uQrT/YSoCqxeEmkqnxQ6RFv8TzIunRytFyx+6//y1MSQpwP/owb3yyVdQ7AiFc0QG6/4C+DfAO88WLbJ+Q+NoYzEwVts3zGPCVvtOsQHhIevyeZJ69h+g2xjmv8mMhOPHozDVCM3EL6IX0OMFlZQnCTHY0= Received: by 10.101.70.5 with SMTP id x5mr2742463ank.93.1206028975068; Thu, 20 Mar 2008 09:02:55 -0700 (PDT) Received: by 10.100.134.19 with HTTP; Thu, 20 Mar 2008 09:02:55 -0700 (PDT) Message-ID: Date: Thu, 20 Mar 2008 18:02:55 +0200 From: veejar To: pgsql-admin@postgresql.org Subject: Reading information from crashed PGDATA MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/171 X-Sequence-Number: 28654 This information I have found in PostgreSQL docs: Table 52-1. Contents of PGDATA PG_VERSION A file containing the major version number of PostgreSQL base Subdirectory containing per-database subdirectories global Subdirectory containing cluster-wide tables, such as pg_database pg_clog Subdirectory containing transaction commit status data pg_multixact Subdirectory containing multitransaction status data (used for shared row locks) pg_subtrans Subdirectory containing subtransaction status data pg_tblspc Subdirectory containing symbolic links to tablespaces pg_twophase Subdirectory containing state files for prepared transactions pg_xlog Subdirectory containing WAL (Write Ahead Log) files postmaster.opts A file recording the command-line options the server was last started with postmaster.pid A lock file recording the current server PID and shared memory segment ID (not present after server shutdown) When I have only folder base or base+global, can I read tables data from databases in such PGDATA via any tools or methods?