Re: [ADMIN] Recovery - transaction logs

2002-02-07 Thread Andy Marden
I'm just coming at this from the point of view of someone who's implementing PostgreSQL for the first time, but has in-depth Oracle experience. This is the one area left where organisations are going to discount PostgreSQL because they can't afford to tell people that all data entered that day has

[ADMIN] pg_dumpall won't work?

2002-02-07 Thread Joel Mc Graw
I tried to run pg_dumpall and I got "strdup: failed to allocate memory". I tried to run it again and I get a segmentation fault. Any ideas how to back up this (production) database? PostgreSQL 7.1.3 on FreeBSD 4.2 Release TIA, Joel ---(end of broadcast)--

Re: [ADMIN] Recovery - transaction logs

2002-02-07 Thread Bruce Momjian
Andy Marden wrote: > I'm just coming at this from the point of view of someone who's > implementing PostgreSQL for the first time, but has in-depth > Oracle experience. This is the one area left where organisations > are going to discount PostgreSQL because they can't afford to > tell people that

[ADMIN] PG 7.2 tarball

2002-02-07 Thread Simone Tellini
Hi there, I've just downloaded the sources tarball from http://www.postgresql.org/ftpsite/v7.2/postgresql-7.2.tar.gz but I can't unpack it: postgresql-7.2/configure.in gzip: stdin: invalid compressed data--crc error is the file on the server corrupt or should I try to download it again? --

Re: [ADMIN] PG 7.2 tarball

2002-02-07 Thread Phill Kenoyer
Try: tar xfz postgresql-7.2.tar.gz or: tar xf postgresql-7.2.tar.gz If you use Netscape to download it, it is already un-gziped. If both of the commands above do not work, then you may need to re-download it. |On 020207 09:52 |Simone Tellini ([EMAIL PROTECTED]) wrote the following... | |Hi th

Re: [ADMIN] pg_dumpall won't work?

2002-02-07 Thread Tom Lane
Joel Mc Graw <[EMAIL PROTECTED]> writes: > I tried to run pg_dumpall and I got "strdup: failed to allocate > memory". I tried to run it again and I get a segmentation fault. Strange. Can you provide a debugger backtrace from the segfault? Another thing that might be useful is to log the queries

Re: [ADMIN] PG 7.2 tarball

2002-02-07 Thread Chris Ruprecht
well, with gnu tar, the command is actually tar -zxvf postgresql-7.2.tar.gz with the '-' and the 'v' optional The 'z' tells tar that the file is compressed. Best regards, Chris At 09:57 -0800 02/07/2002, Phill Kenoyer wrote: >Try: tar xfz postgresql-7.2.tar.gz >or: tar xf postgresql-7.2.tar.

Re: [ADMIN] PG 7.2 tarball

2002-02-07 Thread Phill Kenoyer
Just a note: $ tar --version tar (GNU tar) 1.13.25 $ tar -zxf test.tar.gz $ tar zxf test.tar.gz Both work fine. $ tar -fxz test.tar.gz tar (child): test.tar.gz: Cannot open: No such file or directory ... $ tar fxz test.tar.gz $ I just learned today that if I use the '-', then f needs to be la

Re: [ADMIN] PG 7.2 tarball

2002-02-07 Thread Simone Tellini
On Thu, 7 Feb 2002 09:57:34 -0800 Phill Kenoyer <[EMAIL PROTECTED]> wrote: PK> Try: tar xfz postgresql-7.2.tar.gz PK> or: tar xf postgresql-7.2.tar.gz PK> PK> If you use Netscape to download it, it is already un-gziped. I've used wget, and I know how to use tar, thanks :) The error happens