| From: | "Alessandro (at) GMail" <neurotrotter(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: weird problem with pgadmin & postgres on debian |
| Date: | 2006-03-18 17:25:32 |
| Message-ID: | 441C428C.2090606@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000066">
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)<br>
<br>
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? <br>
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...<br>
<br>
thx<br>
Alessandro<br>
<br>
Dave Page wrote:
<blockquote cite="mid006d01c64a92$a8eaaeb0$6a01a8c0(at)valehousing(dot)co(dot)uk"
type="cite">
<pre wrap="">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"<a class="moz-txt-link-rfc2396E" href="mailto:neurotrotter(at)gmail(dot)com"><neurotrotter(at)gmail(dot)com></a>
Sent: 18/03/06 13:12:01
To: <a class="moz-txt-link-rfc2396E" href="mailto:pgadmin-support(at)postgresql(dot)org">"pgadmin-support(at)postgresql(dot)org"</a><a class="moz-txt-link-rfc2396E" href="mailto:pgadmin-support(at)postgresql(dot)org"><pgadmin-support(at)postgresql(dot)org></a>
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
</pre>
</blockquote>
<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 3.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Madu | 2006-03-18 18:13:28 | postgreSQL txt dump restore |
| Previous Message | Dave Page | 2006-03-18 13:48:28 | Re: weird problem with pgadmin & postgres on debian |