[GENERAL] vacuumdb problem
Hi! I have a problem with vacuumdb on one of my tables. (spiral:3)-[~]$vacuumdb -t osoby -v dziekanat NOTICE: --Relation osoby-- NOTICE: Pages 229: Changed 0, reaped 16, Empty 0, New 0; Tup 4427: Vac 5, Keep/VTL 0/0, Crash 0, UnUsed 70, MinLen 64, MaxLen 616; Re-using: Free/Avail. Space 18176/2288; EndEmpty/Avail. Pages 1/10. CPU 0.02s/0.00u sec. NOTICE: Index osoby_Imię_key: Pages 44; Tuples 4427: Deleted 0. CPU 0.01s/0.01u sec. NOTICE: Index osoby_pkey: Pages 15; Tuples 4427: Deleted 0. CPU 0.00s/0.00u sec. NOTICE: Rel osoby: Pages: 229 --> 228; Tuple(s) moved: 0. CPU 0.01s/0.00u sec. NOTICE: FlushRelationBuffers(osoby, 228): block 223 is referenced (private 0, global 1) FATAL 1: VACUUM (vc_repair_frag): FlushRelationBuffers returned -2 pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. connection to server was lost vacuumdb: vacuum failed this table is referenced in my db by a tree of FOREIGN KEYs. however my db seems to work and I am able to do pg_dump Rescently, I dumped and restored it and for a few days I was able to do vacuumdb. Today, the problem is here again. any ideas? thanks for any help. (I use Postgres ver 7.0.2 on Debian Potato/ dual PII box)
Re: [GENERAL] Announce: Testers needed for revised pg_dump/pg_restore
It's probably best to look in the directory: ftp://ftp.rhyme.com.au/pub/ for the latest version. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 0500 83 82 82 | ___ | Http://www.rhyme.com.au |/ \| |---- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/
Re: [GENERAL] disk backups
Philip Warner wrote: > > At 23:34 1/07/00 +1000, Martijn van Oosterhout wrote: > > > >> Philip Warner needs alpha testers for his new version of pg_dump ;-). > >> Unfortunately I think he's only been talking about it on pghackers > >> so far. > > > >What versions does it work on? > > > > 6.5.x and 7.0.x. > > Which version are you running? Some version that came with redhat (6.5.x) (i didn't install this machine). I'll grab it and see if it works -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://cupid.suninternet.com/~kleptog/
Re: [GENERAL] pg_dumpall and check constraints
Philip Warner wrote:
> At 11:33 1/07/00 +0200, Jan Wieck wrote:
> >
> >Was late for me too, and maybe the answer was too lazy. So
> >let me give you an example of what I meant:
> >
>
> About 5 mins after I hit the send button on my last message I realized the
> error in my ways (again). There are probably limitations one could place on
> such views, but the effort would be high, and the rewards low.
>
> But, at the risk of yet another ill conceived plan being laid bare, and to
> satisfy the original posters requirements, could FOREIGN KEY be extended to
> allow:
>
> FOREIGN KEY({|}...) references ({}...)
>
> This seems like a very convenient feature...if it's not too hard.
The only reason why someone wants to put a into the
foreign key seems to me as a referencing table identifier. So
that multiple referencing tables would all have their own
possible values in one big primary key table.
First this is already possible by adding such a table
identifier field to the referencing tables and having a
BEFORE trigger enforcing the correct value.
Second it's allways good practice to keep things separate
that are separate.
Thus I don't see the need to add non SQL standard features to
FOREIGN KEY.
Jan
--
#==#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#== [EMAIL PROTECTED] #
Re: [GENERAL] vacuumdb problem
Marcin Inkielman <[EMAIL PROTECTED]> writes: > NOTICE: FlushRelationBuffers(osoby, 228): block 223 is referenced > (private 0, global 1) > FATAL 1: VACUUM (vc_repair_frag): FlushRelationBuffers returned -2 > this table is referenced in my db by a tree of FOREIGN KEYs. Hmm, I wonder whether there is a buffer-refcount leak in the foreign key stuff. > however my db seems to work and I am able to do pg_dump > Rescently, I dumped and restored it and for a few days I was able to > do vacuumdb. Today, the problem is here again. You will probably find that stopping and restarting the postmaster will make the problem go away (until it comes back again). Might be an acceptable workaround to let you vacuum, until we can find the bug. Do you think you can extract a reproducible example? Short of that, it'd be helpful to at least see the declarations of "osoby" and all associated tables. regards, tom lane
Re: [GENERAL] disk backups
At 23:36 2/07/00 +1000, Martijn van Oosterhout wrote: > >Some version that came with redhat (6.5.x) (i didn't >install this machine). I'll grab it and see if it >works I'll need to put the 6.5 version on the FTP site first... Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 0500 83 82 82 | ___ | Http://www.rhyme.com.au |/ \| |---- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/
[GENERAL] 2 phase commit abilities
Hi, I am currently in the process of evaluating DB solutions on Linux, and I need to know if it is possible to do 2-phases-commit with PosgreSQL. I would also need some ideas on performances, so if anybody can share anything n this subject, he/she is welcome !! Thanks in advance, Regards, -- Christophe Doré Audientia - Core Engineering [EMAIL PROTECTED] tel : +33 1 46 22 40 00
Re: [GENERAL] Nested transactions
On Mon, 26 Jun 2000, Andrea Aime wrote: > does postgres support nested transactions? No. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden
[GENERAL]
Dear PostgreSQL Expert, I'm looking for the help on the PostgreSQL installation matter. Could you give me such an advice or readdress me to some other experienced people? The problem is following. I got the PostgreSQL ver.7.0.2 from the Postgres site and compiled it on HP-UX machine under OS hppa1.1-hp-hpux10.20. While configuring, I set the prefix= to subdirectory in my account since I'm not a root and have no superuser access rights, and added explicitly "--template=hpux_cc". Also, I got GNU make to build the package. Following the INSTALL guide, I compiled the package and tried to start the Regression Test in parrallel mode to check the system before installation. The Test passed until the following lines were diplayed: "... sequential test numerology ... ok parallel group2 (15 tests) ... lseg point " and then many hours passed with no change happened. I tried to recompile the binaries using the "-O" option for cc-compiler, with or without-CXX. The test ran the same way every time. What TODO? thank you in advance Nicolai Shatsky Royal Observatory of Belgium
[GENERAL] Search engine down ?
Hi, I want to find information into your search engine for postgresql mailing list but I can't find any answer to my search. Typing SELECT or CURSOR or any other words in pgsql-general or pgsql-sql give me no output. Perhaps you have an indexation problem ? Regards
[GENERAL] Perl script for pg_dumpall?
I would like to write a Perl script that will run pg_dumpall, for backup purposes. I am hoping to run this script via the crontab nightly. My question is does anyone know of any resources that will assist me in the code for this script, or any examples of executing Postgres commands in a Perl script? Any help is greatly appreciated. Thanks in advance! Jim
[GENERAL] Regarding editor commands
Hi, What is the equivalent command of "Describe "of Oracle PLSQL editor in Postgres editor .
Re: [GENERAL] Publishing my book
On 29 Jun 00, at 0:57, Bruce Momjian <[EMAIL PROTECTED]> wrote: > http://www.postgresql.org/docs/awbook.html Just curious.will the book always be available here, or will it be taken down once the printed version appears? --Ray. -- Raymond O'Donnell http://www.iol.ie/~rod/organ [EMAIL PROTECTED] (or [EMAIL PROTECTED]) The Irish Pipe Organ Page http://www.iol.ie/~rod --
