If password set by pgadmin contains \ or ' character, it is not possible to
login to pgAdmin
PROBLEM WITH \ character is password
To reproduce
1. Create new login role in pgadmin
2. Enter \ to password field.
3. Select SQL tab
Observed:
CREATE ROLE test LOGIN PASSWORD '\\'
Expected
CREATE RO
OS: Windows XP (Ver 5.1.2600) SP2
pgAmin III: Ver 1.2.2
posgreSQL: Ver 8.0
Hi,
I have a previously made postgresql full schema/data dumpo made to a txt file. How can I restore the database schema/data using pgAdmin, as the available restore facility only seems to work with non txt file backups?
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 use
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"
Subject: Re: [pgadmin-support] weird
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,
