Re: [GENERAL] How can I perform client-only installation from source code on Windows?

2013-04-03 Thread raghu ram
On Wed, Apr 3, 2013 at 3:48 AM, MauMau wrote: > Hello, > > Is there any way to perform client-only installation from source code on > Windows? On UNIX/Linux, client-only installation is described here: > > > http://www.postgresql.org/**docs/current/static/install-**procedure.html

[GENERAL] Why not cascade? (was: Using varchar primary keys)

2013-04-03 Thread Gavan Schneider
On 3/4/13 at 1:49 PM, dix1wji...@sneakemail.com (Julian tempura-at-internode.on.net |pg-gts/Basic|) wrote: ... having to really think it out is probably a good sign that you should stick to a surrogate unless you are really sure. (again I don't advocate ON UPDATE CASCADE as a solution should yo

Re: [GENERAL] How can I perform client-only installation from source code on Windows?

2013-04-03 Thread MauMau
From: "raghu ram" On Wed, Apr 3, 2013 at 3:48 AM, MauMau wrote: Is there any way to perform client-only installation from source code on Windows? On UNIX/Linux, client-only installation is described here: You can download PostgreSQL binaries for windows operating system from below link: ht

[GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread Shaun Thomas
Hey! So, Packt approached me a few months ago and asked me to put together a very basic series of short step-by-step instructions on backing up PostgreSQL. The title is "Instant PostgreSQL Backup and Restore How-to." I tried to cover all of the basic approaches used by most admins, and I tes

Re: [GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread Carlos Mennens
Based on Amazon reviews and others in the PG community, I would 100% get something like this. High Availability / Fail Over are my biggest concerns with PostgreSQL Database. Thanks so much for sharing and good luck!!! On Wed, Apr 3, 2013 at 10:09 AM, Shaun Thomas wrote: > Hey! > > So, Packt app

Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100%

2013-04-03 Thread Kevin Grittner
David Noel wrote: > On 4/2/13, Kevin Grittner wrote: >> David Noel wrote: >> >>> 'select * from pg_stat_activity' shows that the queries are not >>> waiting, and are in the idle state. >> >> The process is idle or the process is running the query?  If the >> latter, what do you mean when you say

[GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-03 Thread Paul Tilles
We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in the near future. Can anyone give me a short list of "gotchas" concerning problems we might step into? We have a number of functions written in PL/pgSQL. Will they work in 9.2.4 without modification? Thanks in advance

[GENERAL] could not load plperl library

2013-04-03 Thread Robert Fitzpatrick
I have a Windows XP laptop I've loaded postgres on for dev purposes. When I try to create the plperl language on a db, I get an error 'cannot load library' referencing the location where plperl.dll does exist. It has the lastest version of ActiveState Perl, but I remember (it's been a while) th

Re: [GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread Igor Neyman
> -Original Message- > From: Shaun Thomas [mailto:stho...@optionshouse.com] > Sent: Wednesday, April 03, 2013 10:09 AM > To: PostgreSQL General > Subject: PostgreSQL Backup Booklet > > Hey! > > So, Packt approached me a few months ago and asked me to put together a > very basic series o

Re: [GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread Shaun Thomas
On 04/03/2013 12:49 PM, Igor Neyman wrote: Is there plans for e-book edition? I believe there already is one. Packt sells it directly, and it's also listed on Amazon. Way cheaper than the print version, I think. About five bucks, as opposed to 20. -- Shaun Thomas OptionsHouse | 141 W. Jack

Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100%

2013-04-03 Thread Eduardo Morras
On Tue, 2 Apr 2013 18:08:36 -0500 David Noel wrote: > On 4/2/13, Kevin Grittner wrote: > > David Noel wrote: > > > >> 'select * from pg_stat_activity' shows that the queries are not > >> waiting, and are in the idle state. > > > > The process is idle or the process is running the query? If the

Re: [GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread Igor Neyman
> -Original Message- > From: Shaun Thomas [mailto:stho...@optionshouse.com] > Sent: Wednesday, April 03, 2013 1:51 PM > To: Igor Neyman > Cc: PostgreSQL General > Subject: Re: PostgreSQL Backup Booklet > > On 04/03/2013 12:49 PM, Igor Neyman wrote: > > > Is there plans for e-book editio

Re: [GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread Joe Van Dyk
On Wed, Apr 3, 2013 at 7:09 AM, Shaun Thomas wrote: > Hey! > > So, Packt approached me a few months ago and asked me to put together a > very basic series of short step-by-step instructions on backing up > PostgreSQL. The title is "Instant PostgreSQL Backup and Restore How-to." > Links for those

Re: [GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread Shaun Thomas
On 04/03/2013 01:07 PM, Joe Van Dyk wrote: Links for those who are interested: Not sure why it's not showing up with the paperback, but the Kindle edition: http://www.amazon.com/Instant-PostgreSQL-Backup-Restore-ebook/dp/B00C26J204 I've never ordered a kindle eBook since I prefer epub, but t

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-03 Thread Tom Lane
Paul Tilles writes: > We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in > the near future. > Can anyone give me a short list of "gotchas" concerning problems we > might step into? You'll need to review the release notes for 8.4, 9.0, 9.1, and 9.2 to see the compatibility

Re: [GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread François Beausoleil
Le 2013-04-03 à 14:10, Shaun Thomas a écrit : > On 04/03/2013 01:07 PM, Joe Van Dyk wrote: > >> Links for those who are interested: > > Not sure why it's not showing up with the paperback, but the Kindle edition: > > http://www.amazon.com/Instant-PostgreSQL-Backup-Restore-ebook/dp/B00C26J204 >

Re: [GENERAL] could not load plperl library

2013-04-03 Thread Paolo Saudin
Try to check the perl version against Postgres version at http://forums.enterprisedb.com/posts/list/3295.page paolo On Wed, Apr 3, 2013 at 7:14 PM, Robert Fitzpatrick wrote: > I have a Windows XP laptop I've loaded postgres on for dev purposes. When > I try to create the plperl language on a db

Re: [GENERAL] How can I perform client-only installation from source code on Windows?

2013-04-03 Thread Hendrik Visage
On Wed, Apr 3, 2013 at 11:52 AM, MauMau wrote: > From: "raghu ram" > >> On Wed, Apr 3, 2013 at 3:48 AM, MauMau wrote: >> >>> Is there any way to perform client-only installation from source code on >>> Windows? On UNIX/Linux, client-only installation is described here: >>> >> >> You can downlo

Re: [GENERAL] Dynamic/polymorphic record/composite return types for C user-defined-functions

2013-04-03 Thread Merlin Moncure
On Tue, Apr 2, 2013 at 12:55 PM, Tom Lane wrote: > Stephen Scheck writes: >> I'm trying to write some user-defined functions in C which operate on a >> large object (so their common first argument will be an OID referencing an >> object in the pg_largeobject catalog table created with lo_create()

[GENERAL] corrupted item pointer in streaming based replication

2013-04-03 Thread Jigar Shah
Hi, Postgres version = 9.1.2 OS = debian(6.0.7) fsync = on full_page_writes = on Setup = Primary and streaming replication based secondary Few days ago we had a situation where our Primary started to through the error messages below indicating corruption in the database. It crashed sometimes and

Re: [GENERAL] corrupted item pointer in streaming based replication

2013-04-03 Thread Lonni J Friedman
You should figure out what base/16384/114846.39 corresponds to inside the database. If you're super lucky its something unimportant and/or something that can be recreated easily (like an index). If its something important, then you're only option is to try to drop the object and restore it from t

Re: [GENERAL] corrupted item pointer in streaming based replication

2013-04-03 Thread Tom Lane
Jigar Shah writes: > Postgres version = 9.1.2 Um, you do realize this is over a year out of date right? (Fortunately, you will have an excellent opportunity to update tomorrow.) > Few days ago we had a situation where our Primary started to through the > error messages below indicating corrupti

[GENERAL] Permissions on large objects - db backup and restore

2013-04-03 Thread David Wall
When we upgraded from PG 8.4 to PG 9.2, we ran into a permissions issue with large objects as discussed here: http://postgresql.1045698.n5.nabble.com/Large-Object-permissions-lost-in-transfer-td4281604.html The basic solution was to do an ALTER LARGE OBJECT and set the OWNER TO using a script

Re: [GENERAL] corrupted item pointer in streaming based replication

2013-04-03 Thread Jigar Shah
We had some disk issues on the primary, but raid verification corrected those blocks. That may have caused the primary to be corrupt. I have identified the objects, they both are indexes relname | relfilenode | relkind +-+- feedback_pac

Re: [GENERAL] Permissions on large objects - db backup and restore

2013-04-03 Thread Tom Lane
David Wall writes: > When we upgraded from PG 8.4 to PG 9.2, we ran into a permissions issue > with large objects as discussed here: > http://postgresql.1045698.n5.nabble.com/Large-Object-permissions-lost-in-transfer-td4281604.html > The basic solution was to do an ALTER LARGE OBJECT and set th

Re: [GENERAL] How can I perform client-only installation from source code on Windows?

2013-04-03 Thread MauMau
From: "Hendrik Visage" On Wed, Apr 3, 2013 at 11:52 AM, MauMau wrote: From: "raghu ram" You can download PostgreSQL binaries for windows operating system from below link: http://www.enterprisedb.com/**products-services-training/**pgbindownload

Re: [GENERAL] corrupted item pointer in streaming based replication

2013-04-03 Thread Tom Lane
Jigar Shah writes: > We had some disk issues on the primary, but raid verification corrected > those blocks. That may have caused the primary to be corrupt. "corrected" for small values of "corrected", I'm guessing :-( > I have identified the objects, they both are indexes > relname

Re: [GENERAL] PostgreSQL Backup Booklet

2013-04-03 Thread Quentin Hartman
Also, Packt has a deal on their site where if you buy 2 ebooks, you get them both for half off. This one seems to qualify, so I Was able to get it for $3, while also getting another book I've been wanting for half what I was expecting to pay. Hooray! QH

Re: [GENERAL] Permissions on large objects - db backup and restore

2013-04-03 Thread David Wall
On 4/3/2013 3:14 PM, Tom Lane wrote: A 9.2->9.2 dump and restore certainly should preserve large object ownership (and permissions, if you've set any). In a quick check I do see "ALTER LARGE OBJECT nnn OWNER TO ..." commands in pg_dump's output for such a case. Are you sure this is really the

Re: [GENERAL] Permissions on large objects - db backup and restore

2013-04-03 Thread Tom Lane
David Wall writes: > On 4/3/2013 3:14 PM, Tom Lane wrote: >> A 9.2->9.2 dump and restore certainly should preserve large object >> ownership (and permissions, if you've set any). In a quick check I do >> see "ALTER LARGE OBJECT nnn OWNER TO ..." commands in pg_dump's output >> for such a case.

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-03 Thread Adrian Klaver
On 04/03/2013 10:14 AM, Paul Tilles wrote: We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in the near future. Can anyone give me a short list of "gotchas" concerning problems we might step into? We have a number of functions written in PL/pgSQL. Will they work in 9.2.4 w