Re: [ADMIN] replica of database

2008-09-10 Thread Scott Marlowe
On Wed, Sep 10, 2008 at 10:52 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > Aftab Alam wrote: >> >> Yes ,I want a replica of my db so that I can use it as failover >> >> >> Version 7.3 linux AS release 4 update 6 > > Version 7.3 is end of life and I don't know of *any* of the replication > techn

Re: [ADMIN] replica of database

2008-09-10 Thread Vishal Arora
From: [EMAIL PROTECTED]: [EMAIL PROTECTED]; [EMAIL PROTECTED]: Thu, 11 Sep 2008 10:14:42 +0530Subject: RE: [ADMIN] replica of database Yes ,I want a replica of my db so that I can use it as failover Version 7.3 linux AS release 4 update 6 I would strongly recommend you to upgrade to 8.

Re: [ADMIN] replica of database

2008-09-10 Thread Joshua D. Drake
Aftab Alam wrote: Yes ,I want a replica of my db so that I can use it as failover Version 7.3 linux AS release 4 update 6 Version 7.3 is end of life and I don't know of *any* of the replication technologies that will work with it. Joshua D. Drake -- Sent via pgsql-admin mailing list (p

Re: [ADMIN] replica of database

2008-09-10 Thread Aftab Alam
Yes ,I want a replica of my db so that I can use it as failover Version 7.3 linux AS release 4 update 6 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vishal Arora Sent: Thursday, September 11, 2008 10:11 AM To: Aftab Alam; pgsql-admin@postgresql.o

Re: [ADMIN] replica of database

2008-09-10 Thread Vishal Arora
Do you mean Replication? There are already several posts about replication. What Platform are you using and what version of PostgreSQL are you using? > From: [EMAIL PROTECTED]> To: pgsql-admin@postgresql.org> Date: Thu, 11 Sep > 2008 09:39:48 +0530> Subject: [ADMIN] replica of database> > Hi al

Re: [ADMIN] sync of db

2008-09-10 Thread Scott Marlowe
On Wed, Sep 10, 2008 at 10:13 PM, Aftab Alam <[EMAIL PROTECTED]> wrote: > Hi all, As mentioned slony might be a good choice. One of the nice features is that you can disconnect the network cable from source to destination and plug it back in a few minutes later and it will just catch up without t

Re: [ADMIN] sync of db

2008-09-10 Thread Aaron Glenn
On Wed, Sep 10, 2008 at 9:13 PM, Aftab Alam <[EMAIL PROTECTED]> wrote: > Hi all, > >How can I sync a db with another db at different location. > > Regards > aftab for what definition of "sync"? If you don't know, perhaps slony would be a good place to start researching. -- Sent via pgsql

[ADMIN] sync of db

2008-09-10 Thread Aftab Alam
Hi all, How can I sync a db with another db at different location. Regards aftab This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the origi

[ADMIN] replica of database

2008-09-10 Thread Aftab Alam
Hi all, Can any one tell me how to replicate a db. Regards aftab This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Furt

Re: [ADMIN] dynamic SQL

2008-09-10 Thread Scott Marlowe
On Wed, Sep 10, 2008 at 9:45 AM, davyd <[EMAIL PROTECTED]> wrote: > Hi list, > I need to create a sql where the name of a tabla is on a variable.. > > vbuffervarchar; > > SELECT buffer > INTO vbuffer > FROM rutas r, unidades u > WHEREr.codigo_ruta = u.codigo_ruta AND > u.cod

Re: [ADMIN] Postgres 8.3.3, GSSAPI, and Windows XP

2008-09-10 Thread Stephen Frost
Peter, * Peter Koczan ([EMAIL PROTECTED]) wrote: > Gritty details: > PostgreSQL 8.3.3 > Windows XP SP2 (32-bit) > Kerberos for Windows 3.2.2 > Server is running on Red Hat Enterprise Linux 5.2, Kerberos 1.6.2 When using GSSAPI and KfW, you need to set a couple of environment variables for libpq t

[ADMIN] Postgres 8.3.3, GSSAPI, and Windows XP

2008-09-10 Thread Peter Koczan
Hello, I'm trying to offer a Windows XP client for Postgres 8.3.3 to my users. I have it built and installed and everything is working except for GSSAPI. I'm getting the following error: C:\temp>S:\postgresql-8.3.3\bin\psql -h mitchell -p 5432 postgres psql: SSPI continuation error: No credential

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Ben Kim
From: "Markova, Nina" <[EMAIL PROTECTED]> I also plan to try to export data in XML format (from Ingres) and import it to Postgres. I didn't find any utility for importing XML data into Postgres. You can possibly use perl's XML::Xpath for XML import (DBIx::XML_RDB for export), assuming the tab

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Steve Holdoway
Why not just export as 'insert into (... ) values (...)' format. If ingres can't export as such, you can write a select statement to do this. Slow, sure - but the lowest common denominator. Steve On Wed, 10 Sep 2008 11:27:58 -0400 "Markova, Nina" <[EMAIL PROTECTED]> wrote: > > I also plan

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
Adrian, The trick seems to work. Thanks! Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: September 10, 2008 11:58 To: Markova, Nina Cc: [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: RE: [GENERAL] FW: How to upload data to postgres --- Orig

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Adrian Klaver
--- Original message -- From: "Markova, Nina" <[EMAIL PROTECTED]> > > I also plan to try to export data in XML format (from Ingres) and import > it to Postgres. > > I didn't find any utility for importing XML data into Postgres. Or just > looking at the wrong documen

[ADMIN] dynamic SQL

2008-09-10 Thread davyd
Hi list, I need to create a sql where the name of a tabla is on a variable.. *vbuffer * varchar; SELECT buffer INTO vbuffer FROM rutas r, unidades u WHEREr.codigo_ruta = u.codigo_ruta AND u.codigo_uni = 'B15_AFF666'; SELECT within(the_geom,(SELECT geomunion(the_geom) from

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
I also plan to try to export data in XML format (from Ingres) and import it to Postgres. I didn't find any utility for importing XML data into Postgres. Or just looking at the wrong document? I run Postgres 8.2.4 Thanks, Nina -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTEC

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Adrian Klaver
On Wednesday 10 September 2008 7:14:50 am Markova, Nina wrote: > Thanks Adrian. > > I have read the Postgres 'copy' - the problem is that Postgres doesn't > understand Ingres format. This is I think where the failure comes from. > If I don't find a tool, I have to write scripts to convert data to >

Re: [ADMIN] [GENERAL] FW: How to upload data to postgres

2008-09-10 Thread Markova, Nina
Thanks Adrian. I have read the Postgres 'copy' - the problem is that Postgres doesn't understand Ingres format. This is I think where the failure comes from. If I don't find a tool, I have to write scripts to convert data to something postgres understand. In the Ingres file with data for each v

[ADMIN] BadGir

2008-09-10 Thread kola toon
hello   There are 200 photos with jpeg format from historical places and buildings of yazd _ The City of Badgir . There is also a map of yazd that located historical area . You PRICE These . To receive Samples or Order this collection , Contact via [EMAIL PROTECTED]     Yours Sicerely ISATIS