Re: Rights for pgadmin3

Hy Guillaume,

Thanks for answering.
Here is the log of my console as I lanch under the current user :

//opt/PostgreSQL/9.0/scripts/launchpgadmin.sh
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3:
/opt/PostgreSQL/9.0/lib/libuuid.so.1: no version information available
(required by /usr/lib64/libSM.so.6)
sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non accordée
16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version
sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non accordée
16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version
sh: /opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump: Permission non accordée
16:05:40: Error: Failed to execute:
/opt/PostgreSQL/9.0/pgAdmin3/bin/pg_dump --version
/opt/PostgreSQL/9.0/scripts/launchpgadmin.sh: line 3: 22646 Erreur de
segmentation
LD_LIBRARY_PATH=/opt/PostgreSQL/9.0/pgAdmin3/lib:/opt/PostgreSQL/9.0/lib:$LD_LIBRARY_PATH
G_SLICE=always-malloc /opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3
/
On the other side, let's have a look of the log under the root user for
the same actions (except the fact that it's working under root user):
//opt/PostgreSQL/9.0/scripts/launchpgadmin.sh
/opt/PostgreSQL/9.0/pgAdmin3/bin/pgadmin3:
/opt/PostgreSQL/9.0/lib/libuuid.so.1: no version information available
(required by /usr/lib64/libSM.so.6)
/
According to me the problem is not coming from pgAdmin but from the
users rights of my system.
I'll appreciate that the community give me advice on the better way to
manage the user/groups on the 9.0 folder tree.

Regards

Le 04/09/2011 16:01, Guillaume Lelarge a écrit :
> On Sun, 2011-09-04 at 15:24 +0200, Florent THOMAS wrote:
>> Hy all of you,
>>
>> I'm running under OpenSuse 11.4 and postgreSQL 9 installed from the
>> enterprisedb website.
>> I've installed all the stuff under the root user.
>> And now when I want to launch the sql panel on a database in the pgadmin
>> panel, pgadmin3 crached.
>> If I do the same with the root user, everything work fine.
>> How can I do for preventing pgadmin3 from crashing under a current user?
>>
> pgAdmin works for me with an unprivileged user. You'll have to tell us
> more about your issue for us to help you. Right now, all I can say is
> that it should work.
>
>