Re: [ADMIN] reg:Import&Export functions

2005-12-15 Thread sandhya
hi. Let me explain more about my problem I stored some of my files as largeobjects in Postgresql Database Through C-Program Using import functionality. My Postgres server is running on Linux OS. Now i want to export these objects through my application which is running on windows O

Re: [ADMIN] reg:Import&Export functions

2005-12-15 Thread Bruno Wolff III
On Thu, Dec 15, 2005 at 11:09:43 +0530, sandhya <[EMAIL PROTECTED]> wrote: > Hi all, > > I have my postgres server running on Linux OS. > I need to export the files from the Linux OS to Windows drive. > Is there any possibilty of doing this? Can you explain this in some more detail? Exporting

Re: [ADMIN] Protecting application table structures and data

2005-12-15 Thread Scott Marlowe
On Thu, 2005-12-15 at 16:23, David Pratt wrote: > Hi Jim. Many thanks for your reply. I guess this is not so great news. I > am sort of at a loss as to what direction to take. I need a db > connection on a couple of threads minimum in my app but also need to > ensure that the information is sec

Re: [ADMIN] Protecting application table structures and data

2005-12-15 Thread David Pratt
Hi Jim. Many thanks for your reply. I guess this is not so great news. I am sort of at a loss as to what direction to take. I need a db connection on a couple of threads minimum in my app but also need to ensure that the information is secure. Regards David Jim C. Nasby wrote: On Thu, Dec 1

Re: [ADMIN] Protecting application table structures and data

2005-12-15 Thread Jim C. Nasby
On Thu, Dec 15, 2005 at 05:01:47PM -0400, David Pratt wrote: > Hi. I am creating a desktop app and am interested in using postgres. I > started this app with sqlite3 which is nice but not multi-threaded so I > have run into its limitations. > > I want to install postgres on the users machine as

Re: [ADMIN] Fw: Please guide me.

2005-12-15 Thread Jim C. Nasby
On Thu, Dec 15, 2005 at 11:32:45AM +0100, Peter Eisentraut wrote: > Am Donnerstag, 15. Dezember 2005 10:54 schrieb sandhya: > > I have install postgresql on Redhat AS 4.Now we want to migrate data from > > oracle 8i to postgresql 8.1 and want to create snapshots , materialized > > view,dblink,taki

Re: [ADMIN] Copy Command out of memory

2005-12-15 Thread Jim C. Nasby
On Wed, Dec 14, 2005 at 06:18:07PM -0500, Kevin Keith wrote: > Or can a transaction be bypassed altogether with the COPY command since > any failure (the load is going to an empty table) could easily be solved > with a reload of the data anyway. Work along those lines is currently in-progress.

[ADMIN] Protecting application table structures and data

2005-12-15 Thread David Pratt
Hi. I am creating a desktop app and am interested in using postgres. I started this app with sqlite3 which is nice but not multi-threaded so I have run into its limitations. I want to install postgres on the users machine as part of the set up but want the application, if possible, to be the d

Re: [ADMIN] 0 % Data lost

2005-12-15 Thread Jim C. Nasby
The only way to get 0% data loss is some form of syncronous replication, which is rather difficult to implement, especially across a WAN. There is pgCluster and pgpool, both of which do syncronous replication, but it's also statement based which has some serious rammifications. On Wed, Dec 14, 20

Re: [ADMIN] backup and wal files

2005-12-15 Thread Jim C. Nasby
I haven't played with PITR, but I believe that if PostgreSQL doesn't get the right return code from the archive_command it will keep the WAL files around; maybe that's the problem. On Wed, Dec 14, 2005 at 10:57:38AM +0100, [EMAIL PROTECTED] wrote: > Hello to all ... > I'm trying to install a backu

Re: [ADMIN] backup

2005-12-15 Thread Dianne Yumul
database itself using command pgsql < db name > . It should be psql (not pgsql), at least on versions greater than 7.3. And I agree, postgresql 7.2.2 is pretty outdated. hope this helps. On Dec 15, 2005, at 5:37 AM, Devrim GUNDUZ wrote: Hi, On Thu, 2005-12-15 at 09:00 +0800, Muhammad Fa

Re: [ADMIN] single click, double query

2005-12-15 Thread Stephan Szabo
On Thu, 15 Dec 2005, Szabolcs BALLA wrote: > Hi, > > I have a strange problem with psql 7.4.7. > I have customers who run xp, with sp1 (with sp2 no problem), when they > report from our web-based application they send a query > after a single click. The same queries have been posted twice within a

Re: [ADMIN] single click, double query

2005-12-15 Thread Szabolcs BALLA
Yes, but they are our clients, and I can't say for them: please upgrade your client because if you use our applications the db server will have a performance problem...:( Jaime Casanova wrote: On 12/15/05, Szabolcs BALLA <[EMAIL PROTECTED]> wrote: Hi, I have a strange problem with psql 7

Re: [ADMIN] backup

2005-12-15 Thread Devrim GUNDUZ
Hi, On Thu, 2005-12-15 at 09:00 +0800, Muhammad Farid wrote: > I have installed Suse Linux Opeb Excchange server and its running > using postgresql-7.2.2-35. And my problem here is i cant log in to the > database itself using command pgsql < db name > . What kind of an error message you get? >

Re: [ADMIN] single click, double query

2005-12-15 Thread Jaime Casanova
On 12/15/05, Szabolcs BALLA <[EMAIL PROTECTED]> wrote: > Hi, > > I have a strange problem with psql 7.4.7. > I have customers who run xp, with sp1 (with sp2 no problem), when they > report from our web-based application they send a query > after a single click. The same queries have been posted twi

[ADMIN] single click, double query

2005-12-15 Thread Szabolcs BALLA
Hi, I have a strange problem with psql 7.4.7. I have customers who run xp, with sp1 (with sp2 no problem), when they report from our web-based application they send a query after a single click. The same queries have been posted twice within a few milliseconds. How can I forbid this on db serv

[ADMIN] pls unsubscribe me from this

2005-12-15 Thread murali segu
pls unsubscribe  me from this [EMAIL PROTECTED] thanQ Yahoo! Cars NEW - sell your car and browse thousands of new and used cars online search now Play Santa's Celebrity Xmas Party, an exclusive game from Yahoo!

[ADMIN] unsubscribe pgsql-admin

2005-12-15 Thread Sun Sun
Please unsubscribe my user id [EMAIL PROTECTED] from this group.   Many thanks Sun Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping

Re: [ADMIN] Fw: Please guide me.

2005-12-15 Thread Peter Eisentraut
Am Donnerstag, 15. Dezember 2005 10:54 schrieb sandhya: > I have install postgresql on Redhat AS 4.Now we want to migrate data from > oracle 8i to postgresql 8.1 and want to create snapshots , materialized > view,dblink,taking online backup,logical backup and establish replication > between three

[ADMIN] Fw: Please guide me.

2005-12-15 Thread sandhya
  Hello, I have install postgresql on Redhat AS 4.Now we want to migrate data from oracle 8i to postgresql 8.1 and  want to create snapshots , materialized view,dblink,taking online backup,logical backup and establish replication  between three production server.Plz tell me which documents,

[ADMIN] import/exporting files to a remote Client(needed very much)

2005-12-15 Thread sandhya
hi.   lo_import&lo_export is to import/export the files to  UNIX path name.Am i right?   What i should do inorder to place the file in the local system path (whatever may be the OS like windows/Linux) where the application is running and connected to the remote server running on  Linux O

[ADMIN] reg:Import&Export functions

2005-12-15 Thread sandhya
Hi all,   I have my postgres server running on Linux OS. I need to export the files from the Linux OS to Windows drive. Is there any possibilty of doing this? I am connecting to DB through my VC 7Application. In that i need to export the files from the DB to the local machine where i am ru

[ADMIN] reg:Import&Export functions problem

2005-12-15 Thread sandhya
  - Original Message - From: sandhya To: postgre Cc: sandhya Sent: Thursday, December 15, 2005 11:09 AM Subject: reg:Import&Export functions Hi all,   I have my postgres server running on Linux OS. I need to export the files from the Linux OS to Windows drive. Is there any possi