[GENERAL] error codes when running pg_dumpall from a perl script.
Hi, If this was better posed in a different postgres group, please let me know. I'm having problems when running pg_dumpall from a perl script. Here's the line that's executing the backup. `pg_dumpall -o |bzip2 -z -c > $os_bkup_loc/byt_pgdump_full.bz2` or warn "Error while running probably all OK. $! \n"; During the run the following error is reported "Error while running probably all OK.. Illegal seek " i.e. the error code reported by $! is "Illegal seek" I've ran a backup manually, and there are no error messages. When running the backup from with a perl script, (but not sending the output through bzip2) the error still occurs, but diffing the output of that with the output of pg_dumpall -o when ran from the command line and there's only two minor differences (which seem to be within some objectIDs. I can post that diff if anyone thinks it may help. the environment variables PGUSER and PGPASSWORD are set earlier in the script. I've searched the archives of the mail lists, and found no references to illegal seeks WRT running pg_dump. Anyone got any clues ? -- Simon Crute ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] error codes when running pg_dumpall from a perl script.
"Allan Engelhardt" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > You'll want to ask on the perl groups, but briefly you get an illegal seek when your command writes to the error file descriptor: > > % perl -e '`echo hi 1>&2` or warn "Oops: $! $?";' > hi > Oops: Illegal seek 0 at -e line 1. > > It's a perl feature, not a bug ;-) Try Ahh. Thanks for that. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] WAL and crash ressialiance
Hi, If I have the WAL pointing to a different disk that the main postgres database, and that other disk crashes (say writing to it blocks) what will postgres do ? Will it continue to write OK to the main database, or will the whole thing crash ? or hang waiting for the WAL writes to finish ? Thanks. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] Building DBD::Pg
Hi, I'm trying to install & build DBD::Pg. against Postgres7.1 I've downloaded the latest version (0.98) Postgres was installed via the RPMs. (base, lib, delel, perl, docs, test and server) it's a redhat 6.2 based system but with perl 5.6 installed. perl Makefile.PL runs OK make runs OK, but when I run make test I get the following errors. [simon@sunshine DBD-Pg-0.98]$ make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.0/i686-linux -I/usr/local/lib/perl5/5.6.0 test.pl OS: linux Use of uninitialized value in join at test.pl line 53. DBI->data_sources .. not ok: DBI->connect(dbname=template1) failed: No pg_hb at test.pl line 59 DBI->connect ... not ok: No pg_hb at test.pl line 59. make: *** [test_dynamic] Error 255 Can anyone give me a clue what's wrong ? Thanks. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] How robust is postgresql ?
Thanks for the answer, (and thanks to adb too) > > 7.1 has write-ahead logging (WAL), which does what you are looking for. > See http://www.postgresql.org/devel-corner/docs/admin/wal.html > > The fsync mode also helps with data integiry, but it *really* slows down > the system, unfortunately. Looks like WAL is what we want. I understand that 7.1 should be out in a few weeks ? > > The other question is Backups. Is there anyway to take diferential backups ? > > I.E do a full dump periodically, and then make diferential backups from time > > to time (preferably to a differet box) > > You can do a database dump and back up the SQL generated, or do a > filesystem backup. See > http://www.postgresql.org/devel-corner/docs/admin/backup.html for > information on the specifics. I was looking for ways of backing up only data that had changed since the last backup. The server will probably be hosted with an ISP so I don't want unnecessary data transfers. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[GENERAL] How robust is PostgreSQL
Hi all, We're writing an app in Perl and currently using Oracle as the backend database (via the perl DBI) but due to the costs when we put this live we're thinking of useing Postgresql. However we need to know how crash resistant Posgresql is. Oracle has the "Archive log mode" which writes a log of everything that's casued the database to change. This allows you to recoved it properly in the event of a crash. Does Postgresql have anything simmilar ? I've read about Postgresql's "fsync mode". Does this guarantee that the data is written to the disk properly and that the in the even of a crash (such as power outage etc) the database will still be correct ? The other question is Backups. Is there anyway to take diferential backups ? I.E do a full dump periodically, and then make diferential backups from time to time (preferably to a differet box) Thanks. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster