Re: [ADMIN] pg_restore usage

2004-06-27 Thread Tom Lane
[EMAIL PROTECTED] (Thomas F. O'Connell) writes: > I transfer this file to another server, where the database db does not > exist. I try the following: > pg_restore -C -d db pg_dump20040621.pgsql > pg_restore: [archiver (db)] connection to database "db" failed: FATAL: > database "db" does not exis

[ADMIN] Password with libpq

2004-06-27 Thread Tony Reina
I'm setting my PostgreSQL server to demand md5 encrypted passwords from users. In my C programs (using libpq as the interface), it's no big deal to pass the password through PQconnectdb. However, what about in the general case where my client program doesn't know if a password is required or not.

Re: [ADMIN] Password with libpq

2004-06-27 Thread Tom Lane
[EMAIL PROTECTED] (Tony Reina) writes: > However, what about in the general case where my client program > doesn't know if a password is required or not. Is there any libpq > function to query the server if a password is required? Perhaps, > there's a return value for PQconnectdb which would tell m

Re: [ADMIN] Insert binary data on postgre

2004-06-27 Thread Frank Knobbe
On Fri, 2004-06-25 at 07:43, Eduardo S. Fontanetti wrote: > I forgot a little, or better, a big detail, to do this > translating from binary to ANSI of a file with 100Kb, > it will return something like 50 bytes, and this > process is very, very and very slow. Then I need to > use another way.