[ADMIN] Warm standby recovery failure

2009-01-29 Thread Lee Azzarello
how to get out of this situation more gracefully. Thanks for any help you can offer. _ Lee Azzarello Staff Hacker drop.io -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Warm standby recovery failure

2009-02-03 Thread Lee Azzarello
thank you all for your help. It was indeed my copy script that destroyed the database. I now understand that postgresql shouldn't be concerned with validating a WAL segment, that's the responsibility of the script that hands the segment to postgres. -lee On Fri, Jan 30, 2009 at 9:52 AM, Tom Lane

Re: [ADMIN] Failed sanity check?

2009-02-04 Thread Lee Azzarello
Can you perform queries against tables in that database? You may have to poke around in the systems tables for the object ids in question. -lee On Wed, Feb 4, 2009 at 2:32 PM, Carol Walter wrote: > Hello, > > I'm getting this message when I try to back up one of my databases. Is > there somethi

Re: [ADMIN] recovery question

2009-02-25 Thread Lee Azzarello
Is 00010C2800B1 the same size as the other segments? -lee 2009/2/25 Mark Steben : > Hi listers, > > > > Here is my problem. I am running PITR restore on a machine remote from my > production machine. > > I'm shipping logs over there, compressed, then uncompressing them and > copying

Re: [ADMIN] Question to transaction ID wraparound

2009-02-26 Thread Lee Azzarello
On Wed, Feb 25, 2009 at 5:05 AM, Lentes, Bernd wrote: > Hello ML, > > I'm very new to Postgres. > In the log, i got messages concerning transaction ID wraparound. > I red the documentation and made a vaccum on that database. > In the documentation i also found the hint to look in the database with

Re: [ADMIN] postgresql with storage

2009-02-26 Thread Lee Azzarello
On Thu, Feb 26, 2009 at 7:02 AM, Nagalingam, Karthikeyan wrote: > Hi, > > I have some basic query in postgresql with storage, Please help me for the > following > > 1. What is the best practice to use postgresql with storage. Depends on your workload. My workload has a high number of DELETE state

Re: [ADMIN] index for inet(ip address or ip range)

2009-02-26 Thread Lee Azzarello
On Thu, Feb 26, 2009 at 5:33 AM, Tony Liao wrote: > hello,everybody >   I want to create index for column ip1 and ip2.I know there is a > contrib name ip4r.but the column ip1(ip2) would be a ip address or ip range. >   The query would do select ... where ip1>>='96.168.65.84' or

Re: [ADMIN] warm standby, pg_standby, invalid checkpoint record

2009-03-04 Thread Lee Azzarello
does a file named 000100CD exist anywhere on your disk? -lee On Fri, Feb 27, 2009 at 2:47 AM, Brad Wiemerslage wrote: > > I'm attempting to get warm standby up and running with a pair of servers > running ubuntu 8.04 and postgresql 8.3.  Been following the docs: > > http://www.p