Re: [GENERAL] Invalid Page Header Error

Carlo Curatolo wrote: > When I lauch a vacuumdb, I have an error : ERREUR: en-tête de page invalide > dans le bloc 39639 de la relation base/16384/599662 > > With a > SELECT * FROM pg_catalog.pg_largeobject > > Result is > ERREUR: en-tête de page invalide dans le bloc 39639 de la relation > bas

Re: [GENERAL] Invalid Page Header Error

Thanks for the help. SELECT oid, relname, relkind FROM pg_class WHERE relfilenode = 599662; --> returns nothing. No crash occurs, I have tested the hardware (memory, harddisks, RAID5, stability test...) I have made a little program to read all the LargeObject of my tables, they are all readable.

Re: [GENERAL] Invalid Page Header Error

Carlo Curatolo wrote: > SELECT oid, relname, relkind FROM pg_class WHERE relfilenode = 599662; --> > returns nothing. Maybe the wrong database? Try to find out which object this file belongs to (maybe with oid2name). > No crash occurs, I have tested the hardware (memory, harddisks, RAID5, > stabi

Re: [GENERAL] Invalid Page Header Error

Yes I ran pg_dumpall, create a new cluster and import. Everything seems fine now. How can I prevent that ? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Invalid-Page-Header-Error-tp1925403p5774728.html Sent from the PostgreSQL - general mailing list archive at Nabbl

Re: [GENERAL] Invalid Page Header Error

Carlo Curatolo wrote: > Yes I ran pg_dumpall, create a new cluster and import. Ok, cool. > Everything seems fine now. > > How can I prevent that ? Prevent data corruption? Have good hardware, run the latest PostgreSQL fixes... Most of all, have a good backup so that you can recover. Yours, L

[GENERAL] ident authentication problems postgresql 9.2

I have just done an update on my Debian servers running postgresql 9.2 (Postgres is from 9.2.4-2.pgdg70+1 from apt.postgresql.org) and suddenly can't login to postgresql as postgres with the normal peer/ident authentication over a local Unix socket. I've worked around it (I'm using md5 for the ti

Re: [GENERAL] ident authentication problems postgresql 9.2

On 10/16/2013 06:56 AM, Rory Campbell-Lange wrote: I have just done an update on my Debian servers running postgresql 9.2 (Postgres is from 9.2.4-2.pgdg70+1 from apt.postgresql.org) and suddenly can't login to postgresql as postgres with the normal peer/ident authentication over a local Unix sock

[GENERAL] PostgreSQL vs Mongo

All; One of our clients is talking about moving to Mongo for their reporting/data mart. I suspect the real issue is the architecture of their data mart schema, however I don't want to start pushing back if I can't back it up. Anyone have any thoughts on why we would / would not use Mongo fo

Re: [GENERAL] ident authentication problems postgresql 9.2

On 16/10/13, Adrian Klaver (adrian.kla...@gmail.com) wrote: > On 10/16/2013 06:56 AM, Rory Campbell-Lange wrote: > >I have just done an update on my Debian servers running postgresql 9.2 > >(Postgres is from 9.2.4-2.pgdg70+1 from apt.postgresql.org) and suddenly > >can't login to postgresql as post

[GENERAL] pg_hba.conf broken after cluster upgrade

Hello I just upgraded my postgresql server from 8.4 to 9.2 on ubuntu linux 12.04. I installed the new version then used pg_upgrade to upgrade and replicate the cluster from the old server to the new. Everything appears to have worked well except that I am left with a problem with my pg_hba.conf

Re: [GENERAL] PostgreSQL vs Mongo

On Wed, Oct 16, 2013 at 10:30 AM, CS DBA wrote: > All; > > One of our clients is talking about moving to Mongo for their reporting/data > mart. I suspect the real issue is the architecture of their data mart > schema, however I don't want to start pushing back if I can't back it up. > > Anyone ha

Re: [GENERAL] ident authentication problems postgresql 9.2

Rory Campbell-Lange writes: > Thanks for the suggestion for checking the logs. My apologies for not > checking that. The logs show: > 2013-10-16 16:21:16 BST template1 LOG: local user with ID does not > exist > 2013-10-16 16:21:16 BST template1 FATAL: Peer authentication failed for >

Re: [GENERAL] ident authentication problems postgresql 9.2

On 10/16/2013 8:34 AM, Rory Campbell-Lange wrote: I've just turned the setting in pg_hba.conf from md5 back to peer and reloaded the server so that it now reads as: local all postgrespeer Attempting to log in fails with the following error on t

Re: [GENERAL] Problem with updating hstore extension from 9.2 to 9.3

On Wed, Sep 25, 2013 at 07:29:30PM +0400, Murat Kabilov wrote: > Hello, > > I've just upgraded my database from 9.2.2 to 9.3.0 using pg_upgrade. Besides > I've updated hstore extension ("alter extension hstore update"). > But I can't find new to 9.2 hstore functions such as "hstore_to_json" in my

Re: [GENERAL] ident authentication problems postgresql 9.2

On 16/10/13, Tom Lane (t...@sss.pgh.pa.us) wrote: > Rory Campbell-Lange writes: > > 2013-10-16 16:21:16 BST template1 LOG: local user with ID does > > not exist > > 2013-10-16 16:21:16 BST template1 FATAL: Peer authentication failed > > for user "postgres" > > > However /etc/passwd h

Re: [GENERAL] Major upgrade of PostgreSQL and MySQL

On Sun, Oct 6, 2013 at 11:20:14PM +0800, Patrick Dung wrote: > Noted and thanks. > > I can see that it should be updated in the devel manual page: > http://www.postgresql.org/docs/devel/static/pgupgrade.html Yes, it is updated now, it just takes a few hours. -- Bruce Momjian http://

Re: [GENERAL] PostgreSQL vs Mongo

Hi, On 17 October 2013 02:30, CS DBA wrote: > Anyone have any thoughts on why we would / would not use Mongo for a > reporting environment. hm.. I wouldn't use anything which doesn't support rich SQL as a backed for reporting system. In mongo, simple selects are fine but anything complex require

[GENERAL] Bug? Function with side effects not evaluated in CTE

In a new database test, I create the following table and function: create table tb_item ( item integer ); create or replace function fn_new_item( in_item integer ) returns integer language plpgsql as $_$ begin insert into tb_item values( in_item ); return in_item; end $_$; Then, I exec

Re: [GENERAL] Bug? Function with side effects not evaluated in CTE

By the way, I am running Postres 9.1.9.

Re: [GENERAL] Bug? Function with side effects not evaluated in CTE

Moshe Jacobson writes: > However, It behaves as one would expect if the first CTE is built with INSERT > ... RETURNING. CTEs containing INSERT/UPDATE/DELETE are guaranteed to be executed exactly once. CTEs containing SELECTs are guaranteed to be executed at most once (the documentation phrases t

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

On 10/16/2013 09:46 AM, Bob Jolliffe wrote: Hello I just upgraded my postgresql server from 8.4 to 9.2 on ubuntu linux 12.04. I installed the new version then used pg_upgrade to upgrade and replicate the cluster from the old server to the new. Everything appears to have worked well except that

Re: [GENERAL] Bug? Function with side effects not evaluated in CTE

On Wed, Oct 16, 2013 at 4:26 PM, Tom Lane wrote: > Moshe Jacobson writes: >> However, It behaves as one would expect if the first CTE is built with INSERT >> ... RETURNING. > > CTEs containing INSERT/UPDATE/DELETE are guaranteed to be executed exactly > once. CTEs containing SELECTs are guarante

Re: [GENERAL] PostgreSQL vs Mongo

Hi Kevin, This might help you more http://www.slideshare.net/nurulferdous/nosql-is-it-for-you Cheers, NH . On Wed, Oct 16, 2013 at 10:30 PM, CS DBA wrote: > All; > > One of our clients is talking about moving to Mongo for their > reporting/data mart. I suspect the real issue is the architect

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

On 10/16/2013 04:20 PM, Bob Jolliffe wrote: CCing the list so more eyes can see thid. Hi Adrian Sure. Here are 6 versions of complete pg_hba.conf files: 1. This works (note the auth method is peer not ident. my first post had an error). Complete one line pg_hba.conf file: local all postg

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

On 10/16/2013 4:56 PM, Adrian Klaver wrote: I have never seen this in a pg_hba,conf. Of course I don't get out much:) Not sure of its purpose. It seems to be in the place of the IP mask. i think thats an email program artifact, trying to treat an IP as a URL -- john r p

Re: [GENERAL] Bug? Function with side effects not evaluated in CTE

On 17/10/2013 00:06, Merlin Moncure wrote: That being said, I do think it might be better behavior (and still technically correct per the documentation) if volatile query expressions were force-evaluated. This sounds reasonable for a "yes or no" case like this, but wouldn't it raise the questi

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

On 10/16/2013 05:03 PM, John R Pierce wrote: On 10/16/2013 4:56 PM, Adrian Klaver wrote: I have never seen this in a pg_hba,conf. Of course I don't get out much:) Not sure of its purpose. It seems to be in the place of the IP mask. i think thats an email program artifact,

Re: [GENERAL] PostgreSQL vs Mongo

On Wed, Oct 16, 2013 at 8:30 AM, CS DBA wrote: > All; > > One of our clients is talking about moving to Mongo for their > reporting/data mart. I suspect the real issue is the architecture of their > data mart schema, however I don't want to start pushing back if I can't > back it up. > You want