Re: [ADMIN] l need help

2007-10-24 Thread Tom Lane
"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On 10/24/07, frank asabere <[EMAIL PROTECTED]> wrote: >> could somebody help to install drivers for postgresql on redhat 9 > Assuming you're using the RPMs that came with RH 9, you'll want to > find the postgresql rpms and install the base package. [

Re: [ADMIN] l need help

2007-10-24 Thread Scott Marlowe
On 10/24/07, frank asabere <[EMAIL PROTECTED]> wrote: > could somebody help to install drivers for postgresql on redhat 9 Assuming you're using the RPMs that came with RH 9, you'll want to find the postgresql rpms and install the base package. ---(end of broadcast)

Re: [ADMIN] Taking backup of login roles in postgresql 8.2

2007-10-24 Thread Jeff Frost
Arun, You have to use pg_dumpall with the --globals setting like so: pg_dumpall --globals > globals.sql or pass it through gzip first: pg_dumpall --globals | gzip > globals.sql.gz On Thu, 25 Oct 2007, arun wrote: Hi all, I'm new to this forum. Can any one tell me how to take backup of l

[ADMIN] Taking backup of login roles in postgresql 8.2

2007-10-24 Thread arun
Hi all, I'm new to this forum. Can any one tell me how to take backup of login roles in postgresql. I know how to take database backup. It is giving me all the schemas in the selected database, but not creating the login roles required when restoring the database Thank you

Re: [ADMIN] l need help

2007-10-24 Thread Phillip Smith
> could somebody help to install drivers for postgresql on redhat 9 See http://www.postgresql.org/docs/8.2/static/installation.html And specifically, from http://www.postgresql.org/docs/8.2/static/install- procedure.html Client-only installation: If you want to install only the client application

[ADMIN] l need help

2007-10-24 Thread frank asabere
could somebody help to install drivers for postgresql on redhat 9 frank adu asabere [EMAIL PROTECTED] p.o.box 233 accra - Yahoo! Answers - Get better answers from someone who knows. Tryit now.

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-24 Thread Tom Lane
Craig McElroy <[EMAIL PROTECTED]> writes: >> Can you get a stack trace from the core dump reported here? > Certainly, how can that be obtained? $ gdb /path/to/postgres-executable /path/to/core-file gdb> bt gdb> quit If you don't find a corefile in $PGDATA (or wherever your system puts core fil

Re: [ADMIN] Partitioning and deadlocks

2007-10-24 Thread Brad King
Thanks for the reply. I really want to have something generic to garbage collect old data. This is pretty easy to do with re-writing check constraints but much more verbose if you have drop and recreate rules, since the column lists are different for each table. Also I have several related tables t

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-24 Thread Craig McElroy
Tom: Certainly, how can that be obtained? Cheers, -craig --- Craig McElroy Contegix Beyond Managed Hosting(r) for Your Enterprise On Oct 24, 2007, at 7:12 AM, Tom Lane <[EMAIL PROTECTED]> wrote: Craig McElroy <[EMAIL PROTECTED]> writes: Now, if I include one more WAL file in the recovery,

[ADMIN] Has anyone seen the following error message in the log.txt file when installing postgres

2007-10-24 Thread Jafry, Kamran
Postgres 8.03 Whenever I install Postgres.. I am checking the log.txt file it creates and it has the following... (Oct 24, 2007 11:20:36 AM), Setup.product.install, com.installshield.product.wizardbeans.SetProductBeanPropertyAction, wrn, Unable to set product bean property appLauncherWin.active

Re: [ADMIN] Postgresql takes more time to update

2007-10-24 Thread Suresh Gupta VG
Peter, Thanks for your response. with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph : +9120 66453213 From: Peter Koczan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 3:18 AM To:

Re: [ADMIN] Postgresql takes more time to update

2007-10-24 Thread Suresh Gupta VG
Scott, Thanks for your response. with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph : +9120 66453213 From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 2:17 AM To

Re: [ADMIN] Postgres SQL Client for Suse Linux

2007-10-24 Thread yogesh
On Oct 24, 8:56 am, [EMAIL PROTECTED] (Vishal Arora) wrote: > Hi Yogesh, > > you can build PgAdmin III from source for Suse. > > http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/branches/REL-1_8_0_PATCHES... > > follow the instructions given in the above link. > > Regards, > > Vishal > > > From: [EMAIL P

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-24 Thread Tom Lane
Craig McElroy <[EMAIL PROTECTED]> writes: >Now, if I include one more WAL file in the recovery, ... >> Oct 23 22:22:29 db01b postgres[92]: [ID 748848 local0.info] >> [5706-1] LOG: archive recovery complete >> Oct 23 22:27:06 db01b postgres[91]: [ID 748848 local0.info] [1-1] >> LOG: start

[ADMIN] Problem with PITR Past Particular WAL File

2007-10-24 Thread Craig McElroy
Greetings: I am running into a problem during a failover recover of a particular 8.2.4 database running on SunOS 5.10 box. For complete divulgence of information, I am also using the pg_standby utility from the 8.3 contribs to handle the replay of the logs on the standby server. Wha