I’m also having this problem, it also happens if the connection to the server
is lost. When you click ‘ok’ ’pgAdmin crashes.
As per Lutischán statement below, this was working fine on pgAdmin 1.20.
Interestingly, the application is being used (writing queries and executing
them against the ser
How about if you disconnect from the server in PGAdmin, then right click the
server, click ‘properties’ and enter ‘mydb’ into the ‘Advanced’ tab under ‘DB
Restriction’.
Does that work?
Adam
From: Владимир Янченко [mailto:xooyan...@gmail.com]
Sent: 16 December 2015 11:33 AM
To: Adam Pearson
it list all databases on the server or error?
Try granting those permissions back and try again.
Regards,
Adam Pearson
From: pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of ???
Sent: 16 December 2015 11:04 AM
To: Nikolai Zhubr
Cc
Resolved myself, don’t panic Mr Mannering.
From: Adam Pearson
Sent: 03 December 2015 11:16 AM
To: 'pgAdmin Support'
Subject: pgAdmin and Postgres_fdw needing superuser access
Hello All,
Has anyone encountered a quirk with PGAdmin and Postgres_fdw
requiring superuser ac
es_fdw you specify the connection details in the
user mapping.
Is this a problem with pgAdmin, or Postgres_fdw? Seems to indicate an issue
with pgAdmin?
Thanks & Regards,
Adam Pearson
pen up another one on the same database
the entire query works fine first time around, then fails on the second time.
I still have connection to the database since can query the other tables in the
actual DB I’m connected to.
Any ideas?
Thanks,
Adam Pearson
ERROR: function dblink_disconnect(
le for elevated
permissions. A shame since seems a little clunky.
Thanks again for trying to help.
Adam
-Original Message-
From: Wim Bertels [mailto:wim.bert...@khleuven.be]
Sent: 01 September 2015 12:15 PM
To: Adam Pearson
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmi
im Bertels [mailto:wim.bert...@khleuven.be]
Sent: 01 September 2015 10:56 AM
To: Adam Pearson
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin and sudo mode
Hallo Adam,
if you are a dba,
probably what u are looking for is a superuser account.
start pgadmin,
in the sql window,
type c
Hello all,
Does anyone know if you can use 'sudo' in pgAdmin?
Currently my login doesn't have full access to the system, when I sudo into the
admin account I can alter / drop / create objects / permissions etc.
I don't know the sudo account password and the DevOps team don't hand
