🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: es.comp.os.linux.programacion
Article #11820

Re: postgres y backup

#11820
From: DaVinci
Date: Wed, 26 Sep 2001 18:34
22 lines
1626 bytes
In article <9osvi1$eiicr$1@ID-59646.news.dfncis.de>, [zAtOpEk] wrote:
> No entiendo bien la doc, por estar la que tengo en ingles.

 Hay un proyecto muy avanzado para traducir toda la docu de PostgreSql. El
 problema es que el servidor parece ca�do. Puedes buscarlo con Google.

> si mis BBDD estan debajo de /var/lib/pgsql/data
> como hago un backup de ellas? me refiero a un dump, no se si con pg_dump o
> algo as�....

	pg_dumpall > fichero

> y como se restaurarian?

	psql base_datos < fichero

 Saludos.

-- 
David Espada, a.k.a. |)a\/inci	(davinci@escomposlinux.org)

Debian GNU/Linux Sid
Technical Details
Message-ID: <slrn9r4848.hb.david@lorien.net>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!feed2.news.rcn.net!rcn!dca6-feed2.news.digex.net!sfo2-feed1.news.digex.net!intermedia!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed.bcn.ttd.net!news.bcn.ttd.net!frodo.audiolis.com!127.0.0.1!news.audiolis.com!127.0.0.1!news.antakira.com!not-for-mail
References: <9osvi1$eiicr$1@ID-59646.news.dfncis.de>

Show Full Headers
Complete Article Headers
X-Google-Language: SPANISH,ASCII
X-Google-Thread: f86c8,34b9c484c2f369df
X-Google-Attributes: gidf86c8,public
X-Google-ArrivalTime: 2001-09-26 12:01:03 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!feed2.news.rcn.net!rcn!dca6-feed2.news.digex.net!sfo2-feed1.news.digex.net!intermedia!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed.bcn.ttd.net!news.bcn.ttd.net!frodo.audiolis.com!127.0.0.1!news.audiolis.com!127.0.0.1!news.antakira.com!not-for-mail
From: DaVinci <david@lorien.net>
Newsgroups: es.comp.os.linux.programacion
Subject: Re: postgres y backup
Date: 26 Sep 2001 18:34:43 GMT
Organization: Seelie court
Lines: 22
Message-ID: <slrn9r4848.hb.david@lorien.net>
References: <9osvi1$eiicr$1@ID-59646.news.dfncis.de>
NNTP-Posting-Host: 213.97.227.24
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: slrn/0.9.7.2 (Linux)