[GENERAL] getting failed while creating user accounts

2006-03-12 Thread venu gopal
Hi all, I m trying to install postgres8.1 on my system.I tried with account name postgres.I was getting an error of unable to create user account.user account already exists. If i try with any other user any of the following error is arising 1.unable to create user account.user account alre

Re: [GENERAL] getting failed while creating user accounts

2006-03-12 Thread Andreas Kretschmer
venu gopal <[EMAIL PROTECTED]> schrieb: > Please give me the suggestions where i have to make > changes to make my installation to be > successful.Please reply me ASAP Please tell us your OS and distribution. Why you don't use a package for your distribution? I have DEBIAN without any problems.

Re: [GENERAL] getting failed while creating user accounts

2006-03-12 Thread Ycrux
Hi! Try : http://yhafri.club.fr/crux/postgresql/Pkgfile http://yhafri.club.fr/crux/postgresql/README Let me know if you still have install problems cheers Younes venu gopal a écrit : Hi all, I m trying to install postgres8.1 on my system.I tried with account name postgres.I was getting an

[GENERAL] COPY has no access permissions

2006-03-12 Thread P G
Hello, I found something interesting when I try to load a text file into a table. I am on Windows XP and I am using the Copy command. If the file is under C:\Documents And Settings or anywhere under that folder, the database complains that it has no access permissions. (The file is on my deskt

Re: [GENERAL] Autovacuum Daemon Disrupting dropdb?

2006-03-12 Thread Thomas F. O'Connell
On Mar 11, 2006, at 4:13 PM, Tom Lane wrote: For a "real" solution, perhaps DROP DATABASE could somehow look to determine if there's an autovac daemon active in the target database, and if so send it a SIGINT and wait for it to go away. In general, it also seems like a --force option or somet

Re: [GENERAL] getting failed while creating user accounts

2006-03-12 Thread Javier Carlos
Hi, In some *nix distributions the username 'postgres' is already in /etc/passwd. If so, you don't need to create it again. Just assure that the directory where the database cluster will reside belongs to the user 'postgres', and also when you'll go to create the DB cluster (with the command

[GENERAL] Java Studio Creator

2006-03-12 Thread Bob Pawley
Hi   I'm having trouble connecting the Postgresql JDBC drivers to Java Studio Creator. No matter which of the Postgresql drivers, for version 8.1,  that I attempt for connection I continue to get an error message "wrong driver: org.postgresql.Driver for url: localhost"   I am trying to determ

Re: [GENERAL] COPY has no access permissions

2006-03-12 Thread P G
Thanks, Mike! Your solution seems to have solved it. --- mike <[EMAIL PROTECTED]> wrote: > XP is denying access to your desktop to the postgres > account which the > database service is running on. If you go to the > folder C:\Document and > Settings\your_login_id, right click on it, select >

Re: [GENERAL] Java Studio Creator

2006-03-12 Thread Eric B. Ridge
On Mar 12, 2006, at 4:47 PM, Bob Pawley wrote: Hi I'm having trouble connecting the Postgresql JDBC drivers to Java Studio Creator. No matter which of the Postgresql drivers, for version 8.1, that I attempt for connection I continue to get an error message "wrong driver: org.postgresql.D

Re: [GENERAL] Autovacuum Daemon Disrupting dropdb?

2006-03-12 Thread Tom Lane
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: > On Mar 11, 2006, at 4:13 PM, Tom Lane wrote: >> For a "real" solution, perhaps DROP DATABASE could somehow look to >> determine if there's an autovac daemon active in the target database, >> and if so send it a SIGINT and wait for it to go away.

Re: [GENERAL] Java Studio Creator

2006-03-12 Thread Michael Schmidt
Bob, The JDBC drivers work fine for me - using PostgreSQL 8.1.3 and Windows XP.  From your error message, it looks like JDBC is on your classpath, which is good.  The connection string can be a little finicky.  There is a document on the PostgreSQL website that I found helpful in getting my

Re: [GENERAL] Autovacuum Daemon Disrupting dropdb?

2006-03-12 Thread Stuart Bishop
Tom Lane wrote: > "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: >> On Mar 11, 2006, at 4:13 PM, Tom Lane wrote: >>> For a "real" solution, perhaps DROP DATABASE could somehow look to >>> determine if there's an autovac daemon active in the target database, >>> and if so send it a SIGINT and wai