Re: [ADMIN] Share Data between PostgreSQL and Oracle

2003-10-22 Thread Raja Kumar Thatte
Hai friend Perl DBI and DBD cab be user for accessing oracle or postgress. I think, you are looking for this kind of solution Regards raja --- David Wagoner <[EMAIL PROTECTED]> wrote: > Anyone have experience doing this? I would like to > hear your tips and > experiences. > > Here's our situati

Re: [ADMIN] Need PGSQL ODBC Driver for Solaris

2003-10-22 Thread scott.marlowe
If you need a generic client side ODBC for unix, look also at www.iodbc.org. Nice little LGPL odbc driver, we use it to connect to non-pgsql databases at work and it's quite stable. On Wed, 22 Oct 2003, David Wagoner wrote: > Jeff, > > Thanks, I saw that page but thought is was only for Wind

[ADMIN] Multi-Language server

2003-10-22 Thread Stephen J. Thompson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all, I am looking for suggestions to the following problem. I need to run a database server that needs to allow the entry and searching in multiple languages including multibyte ones. Does anyone have reccomendations on the database server c

Re: [ADMIN] Need PGSQL ODBC Driver for Solaris

2003-10-22 Thread David Wagoner
Title: Need PGSQL ODBC Driver for Solaris Jeff,   Thanks, I saw that page but thought is was only for Windows since it said Win32.  But, I'll try it on Solaris and see what happens.   Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigit

Re: [ADMIN] [PERFORM] Low Insert/Update Performance

2003-10-22 Thread Rhaoni Chiu Pereira
Hi List; Here follow the update query, explain analyze of it , my postgresql.conf and my db configuration. This is my first PostgreSQL DB so I would like to know if its performance is normal ! If there is some postgresql.conf's parameter that you think will optmize the database just tell me

Re: [ADMIN] Need PGSQL ODBC Driver for Solaris

2003-10-22 Thread Jeff
On Wed, 22 Oct 2003 10:01:54 -0400 David Wagoner <[EMAIL PROTECTED]> wrote: > Can anyone tell me where to find a PostgreSQL ODBC driver for Solaris > that I can use to share data with an Oracle database? > > Any suggestions or links to docs appreciated. > http://gborg.postgresql.org/project/psq

Re: [ADMIN] Problems while starting DB

2003-10-22 Thread Sathish Somanathan
I set the System V IPC parameters to the suggested defaults and it worked. set shmsys:shminfo_shmmax=0x200 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=256 set shmsys:shminfo_shmseg=256 set semsys:seminfo_semmap=256 set semsys:seminfo_semmni=512 set semsys:seminfo_semmns=512 set semsy

Re: [ADMIN] File system level backup

2003-10-22 Thread scott.marlowe
On Wed, 22 Oct 2003, Ganesan Kanavathy wrote: > All the while I was doing pg_dump as backup method for my pgsql db. > Today I came across File system level backup on Postgresql > Documentation. > > After reading it, I am quite unsure whether File system level backup is > better than pg_dump. >

[ADMIN] Share Data between PostgreSQL and Oracle

2003-10-22 Thread David Wagoner
Title: Share Data between PostgreSQL and Oracle Anyone have experience doing this?  I would like to hear your tips and experiences. Here's our situation.  We have an Oracle DB on Sun Solaris 8 and a PostgreSQL DB on Linux (RH 7.3) that we need to share data between, specifically from Postgre

[ADMIN] Need PGSQL ODBC Driver for Solaris

2003-10-22 Thread David Wagoner
Title: Need PGSQL ODBC Driver for Solaris Can anyone tell me where to find a PostgreSQL ODBC driver for Solaris that I can use to share data with an Oracle database? Any suggestions or links to docs appreciated. Best regards, David B. Wagoner Database Administrator Arsenal Digital Soluti

Re: [ADMIN] Problems while starting DB

2003-10-22 Thread Tom Lane
Sathish Somanathan <[EMAIL PROTECTED]> writes: > IpcSemaphoreCreate: semget(key=5432001, num=17, 03600) failed: Invalid argument It sounds like you don't have SysV semaphore support enabled, or perhaps just have the limits set too low. See http://www.postgresql.org/docs/7.3/static/kernel-resource

Re: [ADMIN] File system level backup

2003-10-22 Thread Jeff
On Wed, 22 Oct 2003 09:12:40 +0800 "Ganesan Kanavathy" <[EMAIL PROTECTED]> wrote: > All the while I was doing pg_dump as backup method for my pgsql db. > Today I came across File system level backup on Postgresql > Documentation. > If you do a filesystem level backup the only "safe" way to do t

[ADMIN] Problems while starting DB

2003-10-22 Thread Sathish Somanathan
HI All, I am trying to get postgres 7.3.2 to work on a solaris 8 machine. Compile/Installation went smoothly. When I try to start the DB using the command - /opt/CSCOets/pgsql/bin/pg_ctl -D /opt/CSCOets/pgsql/data -l /var/sandbox/testdb/logfile start I get the following error in the logfile