Re: [pgadmin-support] weird problem with pgadmin & postgres on debian

[Alessandro @ GMail]

mmm i think you're right and it's not the same installation as i have not defined the PGDATA environment variable yet, so i don't know what he started at boot time...(i run the db with the -D option right now) another thing i forgot to say is that the first time i put the data folder in my user home(/home/alex/.postgres/data) instead of /usr/local/pgsql/data/ ...but user postgres should be a SU so it shouldn't make any difference, or am i wrong? then i changed the folder to /usr/local/pgsql/data/ but pgadmin refused still to connect. Only after i slaughtered /etc/init.d/postgresql-8.1 i was able to connect with pgadmin... thx Alessandro Dave Page wrote: Are you sure you're starting the same installation/cluster? Manually/init shouldn't make any difference if so. Regards, Dave -----Original Message----- From: "Alessandro @ GMail"<[EMAIL PROTECTED]> Sent: 18/03/06 13:12:01 To: "pgadmin-support@postgresql.org"<pgadmin-support@postgresql.org> Subject: Re: [pgadmin-support] weird problem with pgadmin & postgres on debian ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it, don't now why but it works, maybe it's a problem of user rights, but i'm too noob to know :P ---------------------------------------------------------------- hello there, (it's the first time i use a mailing list...wow!) So, here's my problem: I've installed postgresql on debian as well as pgadmin(everything updated to last version). Now, when i try to access my server on localhost with pgadmin, i cannot enter because it asks me the password. But i have no password, as it's just a first-time learning-purpose install! If i simply leave the password field empty, it rejects my login( "Error connecting to the server: fe_sendauth: no password supplied" ). But, if i try to access the server with 'psql testdatabase' from a terminal, i am able to enter, and work normally. I've also installed postgresql & pgadmin on windows xp (database different from the linux one) and pgadmin acts normally, letting me login and managing databases without any problem. What's wrong? thx -----Unmodified Original Message----- ok, i fixed it by removing the postmaster daemon from init.d and starting postgres manually every time i need it, don't now why but it works, maybe it's a problem of user rights, but i'm too noob to know :P ---------------------------------------------------------------- hello there, (it's the first time i use a mailing list...wow!) So, here's my problem: I've installed postgresql on debian as well as pgadmin(everything updated to last version). Now, when i try to access my server on localhost with pgadmin, i cannot enter because it asks me the password. But i have no password, as it's just a first-time learning-purpose install! If i simply leave the password field empty, it rejects my login( "Error connecting to the server: fe_sendauth: no password supplied" ). But, if i try to access the server with 'psql testdatabase' from a terminal, i am able to enter, and work normally. I've also installed postgresql & pgadmin on windows xp (database different from the linux one) and pgadmin acts normally, letting me login and managing databases without any problem. What's wrong? thx