From yogvinder@newgen.co.in Wed Nov 16 10:56:08 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B583DD6D50 for ; Wed, 16 Nov 2005 06:56:08 -0400 (AST) 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 61909-09 for ; Wed, 16 Nov 2005 10:56:10 +0000 (GMT) X-Greylist: delayed 00:06:27.451977 by SQLgrey- Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by svr1.postgresql.org (Postfix) with SMTP id AAFF7D6837 for ; Wed, 16 Nov 2005 06:55:56 -0400 (AST) Received: (qmail 5181 invoked by uid 507); 16 Nov 2005 10:46:56 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.0.3. Clear:RC:0(202.140.41.205):SA:0(-99.4/5.0):. Processed in 1.764167 secs); 16 Nov 2005 10:46:56 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 16 Nov 2005 10:46:55 -0000 Received: (qmail 18005 invoked by uid 504); 16 Nov 2005 10:48:31 -0000 Received: from yogvinder@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.86):. Processed in 2.569438 secs); 16 Nov 2005 10:48:31 -0000 Received: from unknown (HELO ng3054) (192.168.5.86) by ns.newgen.co.in with SMTP; 16 Nov 2005 10:48:28 -0000 Message-ID: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> From: "Yogvinder Singh" To: Subject: restore challenge Date: Wed, 16 Nov 2005 16:15:27 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0124_01C5EAC8.F52664A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.48 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.48 X-Spam-Level: X-Archive-Number: 200511/203 X-Sequence-Number: 19576 This is a multi-part message in MIME format. ------=_NextPart_000_0124_01C5EAC8.F52664A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi, I have the backup of the usr/local/pgsql/data folder can i use this to manually export all the databases to some other = same version installation of postgres? if possible, how come... if not possible why ? thnks in advance yogi ------=_NextPart_000_0124_01C5EAC8.F52664A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi,
    I have the backup of = the=20 usr/local/pgsql/data folder
    can i use this to = manually=20 export all the databases to some other same version installation of=20 postgres?
    if possible, how=20 come...
    if not possible why = ?
thnks=20 in advance
yogi
 
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, coping, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unlessthe sender does so expressly with due authority of Newgen Software TechnologiesLtd and / or its subsidiary Companies, as applicable. ------=_NextPart_000_0124_01C5EAC8.F52664A0-- From gpatnude@hotmail.com Thu Nov 17 15:48:08 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B04CCDB966 for ; Thu, 17 Nov 2005 11:48:08 -0400 (AST) 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 53663-04 for ; Thu, 17 Nov 2005 15:48:12 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 5BE6ADB91B for ; Thu, 17 Nov 2005 11:48:06 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jAHFm3XA045156 for ; Thu, 17 Nov 2005 15:48:03 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jAHFY3OZ041532 for pgsql-admin@postgresql.org; Thu, 17 Nov 2005 15:34:04 GMT (envelope-from news) From: "codeWarrior" X-Newsgroups: pgsql.admin Subject: Re: restore challenge Date: Thu, 17 Nov 2005 07:36:49 -0800 Organization: Hub.Org Networking Services Lines: 32 Message-ID: References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.891 required=5 tests=[ALL_TRUSTED=-1.44, FORGED_HOTMAIL_RCVD2=0.549] X-Spam-Score: -0.891 X-Spam-Level: X-Archive-Number: 200511/224 X-Sequence-Number: 19597 it doesnt work that way.... this is postgreSQL -- a relational database..... you can't just copy the data directory like you can with mySQL or DBase, or BTrieve or any of the "old-school" databases... if you need to backup and restore data you need to look at pg_dump and pg_dumpall and the import statements in psql... ""Yogvinder Singh"" wrote in message news:012701c5ea9a$dbab31a0$5605a8c0@ng3054... hi, I have the backup of the usr/local/pgsql/data folder can i use this to manually export all the databases to some other same version installation of postgres? if possible, how come... if not possible why ? thnks in advance yogi Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, coping, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unlessthe sender does so expressly with due authority of Newgen Software TechnologiesLtd and / or its subsidiary Companies, as applicable. From cbbrowne@acm.org Thu Nov 17 20:18:15 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9B5A4DB5B0 for ; Thu, 17 Nov 2005 16:18:15 -0400 (AST) 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 12407-02 for ; Thu, 17 Nov 2005 20:18:15 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 0ECB2D6D07 for ; Thu, 17 Nov 2005 16:18:13 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jAHKIBWq060294 for ; Thu, 17 Nov 2005 20:18:11 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jAHK45EV020289 for pgsql-admin@postgresql.org; Thu, 17 Nov 2005 20:04:05 GMT (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: restore challenge Date: Thu, 17 Nov 2005 14:04:42 -0500 Organization: cbbrowne Computing Inc Lines: 34 Message-ID: <60fypvgkol.fsf@dba2.int.libertyrms.com> References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:XhP1Egq21Kkak5ASM0OpN2Bn/Sw= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.277 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.163] X-Spam-Score: -1.277 X-Spam-Level: X-Archive-Number: 200511/231 X-Sequence-Number: 19604 "codeWarrior" writes: > it doesnt work that way.... this is postgreSQL -- a relational database..... > you can't just copy the data directory like you can with mySQL or DBase, or > BTrieve or any of the "old-school" databases... if you need to backup and > restore data you need to look at pg_dump and pg_dumpall and the import > statements in psql... Actually, that's wrong. You certainly *can* copy the set of data directories; there is no particular magic here. The data is stored as a set of files in a set of directories; for there to be some other "magical something else" would seem very strange. What you generally can't do safely is to take a copy while the postmaster is up and running, as you risk parts of the data not being consistent with one another. If your OS or disk hardware supports some sort of "snapshotting" technology, so that you can grab a copy of the whole thing as an instant atomic operation, that provides a way to grab a copy while postmaster is running. If not, then you have to take a copy while the postmaster is shut down. The resulting filesystem copy will only be compatible with the same major version of PostgreSQL, and with versions running on the same architecture, but that can still let it be useful. -- (format nil "~S@~S" "cbbrowne" "ntlug.org") http://cbbrowne.com/info/oses.html ">in your opinion which is the best programming tools ? The human brain and a keyboard." -- Nathan Wagner From ajs@crankycanuck.ca Thu Nov 17 21:24:43 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9EAC0DBA97 for ; Thu, 17 Nov 2005 17:24:43 -0400 (AST) 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 44112-02 for ; Thu, 17 Nov 2005 21:24:43 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp103.rog.mail.re2.yahoo.com (smtp103.rog.mail.re2.yahoo.com [206.190.36.81]) by svr1.postgresql.org (Postfix) with SMTP id A69E4DBB05 for ; Thu, 17 Nov 2005 17:24:39 -0400 (AST) Received: (qmail 40899 invoked from network); 17 Nov 2005 21:24:40 -0000 Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@209.222.54.227 with login) by smtp103.rog.mail.re2.yahoo.com with SMTP; 17 Nov 2005 21:24:40 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id D1EE640E6; Thu, 17 Nov 2005 16:24:39 -0500 (EST) Date: Thu, 17 Nov 2005 16:24:39 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: restore challenge Message-ID: <20051117212439.GA26696@phlogiston.dyndns.org> References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> <60fypvgkol.fsf@dba2.int.libertyrms.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <60fypvgkol.fsf@dba2.int.libertyrms.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/233 X-Sequence-Number: 19606 On Thu, Nov 17, 2005 at 02:04:42PM -0500, Chris Browne wrote: > If your OS or disk hardware supports some sort of "snapshotting" > technology, so that you can grab a copy of the whole thing as an > instant atomic operation, that provides a way to grab a copy while > postmaster is running. If not, then you have to take a copy while the > postmaster is shut down. It's also worth noting that you _really really_ want to test that snapshotting capability. I've heard some people grumble about "it didn't work for me" or some such. There are others who've reported it works (and it ought to, if the snapshots work as advertised -- just be sure you know what the snapshots actually are). A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland From cbbrowne@acm.org Fri Nov 18 03:18:18 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 75E7AD84B6 for ; Thu, 17 Nov 2005 23:18:18 -0400 (AST) 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 32257-04 for ; Fri, 18 Nov 2005 03:18:21 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 5AF93D78B6 for ; Thu, 17 Nov 2005 23:18:15 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jAI3IChQ025470 for ; Fri, 18 Nov 2005 03:18:12 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jAI33ev5015561 for pgsql-admin@postgresql.org; Fri, 18 Nov 2005 03:03:40 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: restore challenge Date: Thu, 17 Nov 2005 21:58:44 -0500 Organization: cbbrowne Computing Inc Lines: 27 Message-ID: References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> <60fypvgkol.fsf@dba2.int.libertyrms.com> <20051117212439.GA26696@phlogiston.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, berkeley-unix) Cancel-Lock: sha1:hFgdtkBXypNuKyUtX07ESSiTEU8= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.917 required=5 tests=[ALL_TRUSTED=-1.44, AWL=-0.290, INFO_TLD=0.813] X-Spam-Score: -0.917 X-Spam-Level: X-Archive-Number: 200511/234 X-Sequence-Number: 19607 > On Thu, Nov 17, 2005 at 02:04:42PM -0500, Chris Browne wrote: >> If your OS or disk hardware supports some sort of "snapshotting" >> technology, so that you can grab a copy of the whole thing as an >> instant atomic operation, that provides a way to grab a copy while >> postmaster is running. If not, then you have to take a copy while the >> postmaster is shut down. > > It's also worth noting that you _really really_ want to test that > snapshotting capability. I've heard some people grumble about "it > didn't work for me" or some such. There are others who've reported > it works (and it ought to, if the snapshots work as advertised -- > just be sure you know what the snapshots actually are). To add a grumble, of sorts... People get all excited about separating WAL onto separate disk, to improve performance. Unfortunately, if you do that, that separates the database into two portions, "splitting the atom," as it were. You'll no longer be able to get that atomic snapshot. Oops. -- output = reverse("moc.liamg" "@" "enworbbc") http://linuxdatabases.info/info/spreadsheets.html "I've seen a look in dogs' eyes, a quickly vanishing look of amazed contempt, and I am convinced that basically dogs think humans are nuts." -- John Steinbeck