[ADMIN]

2006-02-21 Thread rohan rasane
Hi, I would like to unsubscribe from the group,thanks for the help provided.

[ADMIN]

2006-02-21 Thread sagar KUDALE
Hi all I want to unsubscribe from the group Thanks for the support. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- T

Re: [ADMIN] binary data types and streaming

2006-02-21 Thread David Durham
Peter Eisentraut wrote: Is there any type of streaming support built into postgres' binary datatype handling? For instance, can I specify a beginning offset for the binary data that I want substring and other such functions are available. Thanks. I didn't realize that string functions co

Re: [ADMIN] binary data types and streaming

2006-02-21 Thread Peter Eisentraut
David Durham wrote: > What are the differences between using the bytea type and the > BLOB type? The bytea type exists, the blob type does not. > Is there any type of streaming support built into postgres' > binary datatype handling? For instance, can I specify a beginning > offset for t

[ADMIN] binary data types and streaming

2006-02-21 Thread David Durham
Hi- I'm looking for information about storing binary data in postgres. I've set up a few tests where in I stored bytea data, but I have a few other questions and I'm wondering if postgres will meet my needs. Just to start off, here's a couple of questions: What are the differences betwe

[ADMIN] Installing my PostgreSQL client

2006-02-21 Thread richard . hardgrave
Hello, We use the PostgreSQL ODBC to track our released software. We have several Windows (XP, 2000) desktops and laptops with the PostgreSQL clients. I have tried, several times, to install the client on my Windows XP laptop without success. The process I have used is the same one th

Re: [ADMIN] Delete performance

2006-02-21 Thread Tom Lane
adey <[EMAIL PROTECTED]> writes: > We are attempting many deletes in our production database for the first > time, and we're getting nowhere fast. > The SQL runs for more than 12 hours to delete 2 million rows, and hasn't > finished each time we've tried it as we've had to cancel it. The usual cau

Re: [ADMIN] problems to install PostgreSQL

2006-02-21 Thread Anjan Dave
Can also use a startup script from the contrib directory of the source. -Original Message- From: sandhya [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 7:14 AM To: Paolo De Simone; pgsql-admin@postgresql.org Subject: Re: [ADMIN] problems to install PostgreSQL Instead of exec

Re: [ADMIN] Disk crash problems: postgres database not functioning anymore

2006-02-21 Thread Alvaro Herrera
Joost Kraaijeveld wrote: > Hi, > > I lost two databases due to a crash of my RAID5 which resulted in a > filesystem corruption. One of the two databases is the "postgres" > maintenance database of which I have no backup. The postgres database generally doesn't have much useful info. You can re

Re: [ADMIN] problems to install PostgreSQL

2006-02-21 Thread sandhya
Instead of executing the command from root ...login as postgres user and try like su - postgres - Original Message - From: "Paolo De Simone" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 21, 2006 5:34 PM Subject: [ADMIN] problems to install PostgreSQL > Hello all, > > i'm trying to

[ADMIN] problems to install PostgreSQL

2006-02-21 Thread Paolo De Simone
Hello all, i'm trying to install postgresql 8.1.3 on AIX 5.2 RISC 6000 the steps - ./configure - gmake - gmake install are OK so i created /usr/local/pgsql/data but when ran - initdb -D /usr/local/pgsql/data had the following result : " The files belonging to this database system will be own

[ADMIN] Disk crash problems: postgres database not functioning anymore

2006-02-21 Thread Joost Kraaijeveld
Hi, I lost two databases due to a crash of my RAID5 which resulted in a filesystem corruption. One of the two databases is the "postgres" maintenance database of which I have no backup. Is it possible to restore that database somehow without reinstalling PostgreSQL? TIA -- Groeten, Joost K