Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-17 Thread Владимир Янченко
Thank you for the support. In general I agree with Nikolai that it is helpful to have ability to use the navigation panel and other tools for my database when I haven't access to others. I'm sure that my case is impossible in the current pgadmin version. After all searches I suggested to use othe

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
Hello, 16.12.2015 16:37, Guillaume Lelarge: [...] Would be quite difficult. And I completely dislike the idea. If you only need the SQL editor, you can already do this by launching PgAdmin directly with the SQL tool. I'm not sure what you mean by "directly with the SQL tool"? Anyway. It could

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Guillaume Lelarge
Le 16 déc. 2015 2:11 PM, "Nikolai Zhubr" a écrit : > > Hello, > 16.12.2015 14:32, Владимир Янченко: > >> Adam, >> >> yes, you're right. I can connect via PSQL, but get error in PSQL, when I >> try to list databases. >> >> That's what I need, because I don't want show all users and all >> databases

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
l.org <mailto:pgadmin-support@postgresql.org> *Subject:* Re: [pgadmin-support] Connection by user with restricted access to pg_database Nikolai, thank you for your answer. I expect that pgadmin connects to my database and I can execute some sql queries to get data. Bu

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Adam Pearson
Cc: Nikolai Zhubr; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Connection by user with restricted access to pg_database Adam, yes, you're right. I can connect via PSQL, but get error in PSQL, when I try to list databases. That's what I need, because I don't want

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Владимир Янченко
ermissions 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 >

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Adam Pearson
: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Connection by user with restricted access to pg_database Nikolai, thank you for your answer. I expect that pgadmin connects to my database and I can execute some sql queries to get data. But instead I get window with error about

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
Hello, 16.12.2015 10:04, Владимир Янченко: [...] 2015-12-15 15:33:54 ERROR : ERROR: permission denied for relation pg_database 2015-12-15 15:33:55 ERROR : ERROR: permission denied for relation pg_tablespace 2015-12-15 15:33:56 ERROR : ERROR: permission denied for relation pg_roles 2015-12-1

[pgadmin-support] Connection by user with restricted access to pg_database

2015-12-15 Thread Владимир Янченко
Hi! We provide access for our customers to their databases. These databases located on the same postgresql cluster, that's why we denied access to pg_database, pg_roles and others to client's users. One of our customer uses pg_admin. He can't connect to database by provided username because there

[pgadmin-support] Connection handling

2015-08-21 Thread Márk Csaba
Hello,   I’ve searched the actual bugs, but it seems nobody has faced to this.   The error: pgAdmin crashes if Server Status opened and: -  Postgres gets restarted -  Connection is lost   To reproduce: -  Open ’pgAdmin’ o   Open ’Server Status’ -  Restart th

Re: [pgadmin-support] connection lost related issues are still *painful*

2013-09-20 Thread Guillaume Lelarge
On Fri, 2013-09-20 at 18:10 +0200, Michal Kozusznik wrote: > A can confirm. > A lot of unwanted behaviour in case of broken connection (including > pgadmin crash). > As far as I remember it has been reported multiple times, and answered > that it is not possible to fix it due to ammount of work n

Re: [pgadmin-support] connection lost related issues are still *painful*

2013-09-20 Thread Michal Kozusznik
A can confirm. A lot of unwanted behaviour in case of broken connection (including pgadmin crash). As far as I remember it has been reported multiple times, and answered that it is not possible to fix it due to ammount of work needed. I still cannot understand how is it possible in case of off

Re: [pgadmin-support] connection lost related issues are still *painful*

2013-09-20 Thread Belbin, Peter
Apologies: I failed to mention that I am using Windows 7 x64 as my workstation platform. The server is running on a unix variant. And, yes, there are firewalls in between, that cut off sessions after x amount of time. Regards, Peter From: Belbin, Peter Sent: Friday, September 20, 2013 10:09

[pgadmin-support] connection lost related issues are still *painful*

2013-09-20 Thread Belbin, Peter
Congrats on the good improvements to pgAdmin. I do still find that when a connection to the distant postgresql server is lost, that pgAdmin behaves badly and sometimes even has to be killed and restarted. What I see happening is akin to someone disconnecting the ethernet cable. Eg: a firewall

Re: [pgadmin-support] connection lost - Edit Data grid

2012-07-23 Thread Guillaume Lelarge
On Mon, 2012-07-23 at 11:07 +0200, Michal Kozusznik wrote: > Edit Data is not able to reconnect after connection lost. > Trying to refresh data first time I get error message "server closed the > connection..." > After closing error pop-up and hitting refresh button again - nothing > happens. >

[pgadmin-support] connection lost - Edit Data grid

2012-07-23 Thread Michal Kozusznik
Edit Data is not able to reconnect after connection lost. Trying to refresh data first time I get error message "server closed the connection..." After closing error pop-up and hitting refresh button again - nothing happens. I would like this grit to be able to reconnect. with regards Michal

Re: [pgadmin-support] Connection color is not correctly changed in query windows connection drop-down.

2010-09-25 Thread Guillaume Lelarge
Hi, Le 24/09/2010 10:55, Valentine Gogichashvili a écrit : > Hallo Guillaume, > > I can reproduce this the following way: > > 1. Create 2 database connections in the tree and choose color for the first > connection and a different color for another one (red for the first and gray > for the secon

Re: [pgadmin-support] Connection color is not correctly changed in query windows connection drop-down.

2010-09-24 Thread Valentine Gogichashvili
Hallo Guillaume, I can reproduce this the following way: 1. Create 2 database connections in the tree and choose color for the first connection and a different color for another one (red for the first and gray for the second one) 2. Go to the first database (red one) and open a Query Window (the

Re: [pgadmin-support] Connection color is not correctly changed in query windows connection drop-down.

2010-09-23 Thread Guillaume Lelarge
Le 23/09/2010 12:18, Valentine Gogichashvili a écrit : > After upgrading to pgAdmin Version 1.12.0 (from Version 1.12 RC1) > database connection color is not correctly changed in query window. > > Now, when choosing a new connection from the dropdown box in query > window, connection color, for th

[pgadmin-support] Connection color is not correctly changed in query windows connection drop-down.

2010-09-23 Thread Valentine Gogichashvili
After upgrading to pgAdmin Version 1.12.0 (from Version 1.12 RC1) database connection color is not correctly changed in query window. Now, when choosing a new connection from the dropdown box in query window, connection color, for the newly chosen connection is not from the connection, that I have

[pgadmin-support] Connection failure asks for password

2007-06-28 Thread Chris Velevitch
I currently have pgAdmin remember my password. When I get a connection failure and then try to connect again, I get asked for my password. Can we get pgAdmin to distinguish between errors due to connection failure and errors due to the password being wrong and have it realise it's a network error

[pgadmin-support] Connection names and Query Windows

2007-05-24 Thread Laurent ROCHE
Hi, (While talking of connection names, see other post "Edit Data windows title") I just realised the connection name was not used at all in the Query window. That's more than a shame because if I want to use another connection, a little window pops up and offer to change database with a dropdow

Re: [pgadmin-support] Connection bug

2006-10-24 Thread Dave Page
> -Original Message- > From: Erwin Brandstetter [mailto:[EMAIL PROTECTED] > Sent: 23 October 2006 23:36 > To: pgadmin-support@postgresql.org > Cc: Dave Page > Subject: Re: Connection bug > > >> An error has occurred: > >> Error connecting to the server: fe_sendauth: no password sup

Re: [pgadmin-support] Connection bug

2006-10-23 Thread Erwin Brandstetter
dpage@vale-housing.co.uk wrote: OK, I should warn you that connecting like this is completely untested and not something we've ever said we'll support. But I'll do what I can... :-) You might consider this method of connecting tested now - I tested it a lot over the last few years. :) It wo

Re: [pgadmin-support] Connection bug (was: Re: pgAdmin beta fixes)

2006-10-23 Thread Dave Page
> -Original Message- > From: Erwin Brandstetter [mailto:[EMAIL PROTECTED] > Sent: 23 October 2006 21:08 > To: pgadmin-support@postgresql.org > Cc: Dave Page > Subject: Connection bug (was: Re: pgAdmin beta fixes) > > Steps to reproduce the crash: > Settings: ->screenshot "settings.png"

[pgadmin-support] Connection Troubleshooting - Password Problem???

2005-02-15 Thread Sunburned Surveyor
pgAdmin Users, I'm trying to make the switch from MySQL to PostgreSQL. I used the latest PostgreSQL 8.0 MSI to install PostgreSQL with no problems. It was installed as a service, and a cluster. I selected "postgres" for the service account name, and a password for the service. I also selected a

Re: [pgadmin-support] connection dropping continued

2004-02-18 Thread Andreas Pflug
Markus Wollny wrote: I think I found out what's causing the connection dropping - it's not really the firewall, it's the dynamic NAT routing. Our admin doesn't want to set up static NAT routing for the developers though if he can help it - he says that this should be reserved for servers. Huh,

Re: [pgadmin-support] connection dropping continued

2004-02-18 Thread Markus Wollny
nt. Regards Markus -UrsprÃngliche Nachricht- Von: James M Doherty Gesendet: Mi 18.02.2004 20:24 An: [EMAIL PROTECTED] Cc: Betreff: Re: [pgadmin-support] connection dropping continued I am not sure of your exact situation, but I

Re: [pgadmin-support] connection dropping continued

2004-02-18 Thread James M Doherty
I am not sure of your exact situation, but I am using a windows client with putty setting up an SSH tunnel to get through the firewall, one of the options on putty allows you to set a keep alive message every XX seconds. I have kept this connection up for days without problems... Jim ---

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Adam H . Pendleton
On Feb 17, 2004, at 5:51 PM, Markus Wollny wrote: The architecture just doesn't fit here - it's two LANs connected over a VLAN, so the firewall is between us and the open internet, even though the PG-server is in it's own LAN. I can not fix the firewall, it's not in my jurisdiction and I cannot tak

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Markus Wollny
Hi! -UrsprÃngliche Nachricht- Von: Andreas Pflug Gesendet: Di 17.02.2004 21:10 An: Dave Page Cc: Markus Wollny; Josh Endries; [EMAIL PROTECTED] Betreff: Re: [pgadmin-support] connection dropping continued

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Markus Wollny
The server is waiting for tcp/ip disconnect, which is never coming because the firewall eats this, resulting in backends waiting to death. Again: you'll have to request your sysadmin to fix the firewall, at least on that pgsql port for

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 17 February 2004 17:42 > To: Markus Wollny > Cc: Josh Endries; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] connection dropping continued > > > > >I wouldn't cal

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 17 February 2004 17:42 To: Markus Wollny Cc: Josh Endries; [EMAIL PROTECTED] Subject: Re: [pgadmin-support] connection dropping continued I wouldn't call that malfunctioning, So

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Andreas Pflug
Markus Wollny wrote: Hi! -Ursprüngliche Nachricht- Von: Andreas Pflug [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Februar 2004 17:40 An: Josh Endries Cc: [EMAIL PROTECTED]; Markus Wollny Betreff: Re: [pgadmin-support] connection dropping continued This is *not* an

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Markus Wollny
Hi! > -Ursprüngliche Nachricht- > Von: Andreas Pflug [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 17. Februar 2004 17:40 > An: Josh Endries > Cc: [EMAIL PROTECTED]; Markus Wollny > Betreff: Re: [pgadmin-support] connection dropping continued > This is *not* an pgA

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Andreas Pflug
Josh Endries wrote: On Tuesday, February 17, 2004 13:03, Markus Wollny wrote: Referring to http://www.mail-archive.com/[EMAIL PROTECTED]/msg02050.html , I'd like to ask if there's going to be some remedy to the problem any time in the near future? We're using PGAdmin III and it's really an extr

Re: [pgadmin-support] connection dropping continued

2004-02-17 Thread Josh Endries
On Tuesday, February 17, 2004 13:03, Markus Wollny wrote: > Referring to > http://www.mail-archive.com/[EMAIL PROTECTED]/msg02050.html > , I'd like to ask if there's going to be some remedy to the problem any > time in the near future? We're using PGAdmin III and it's really an > extremely useful a

[pgadmin-support] connection dropping continued

2004-02-17 Thread Markus Wollny
Hello! Referring to http://www.mail-archive.com/[EMAIL PROTECTED]/msg02050.html , I'd like to ask if there's going to be some remedy to the problem any time in the near future? We're using PGAdmin III and it's really an extremely useful admin-tool for PostgeSQL, but this issue is really quite unne

Re: [pgadmin-support] connection SSL combobox empty

2003-10-20 Thread Jean-Michel POURE
Le Samedi 18 Octobre 2003 01:37, [EMAIL PROTECTED] a écrit : > on Mandrake 9.1, pgAdmin III 1.0.1 binary distribution (rpm). > SSL combobox in connection window is empty :( If you really need SSL, please install the latest snapshots, i.e. http://www.pgadmin.org/snapshots/linux/mandrake91/ pgadmin3

Re: [pgadmin-support] connection SSL combobox empty

2003-10-18 Thread Jean-Michel POURE
Le Samedi 18 Octobre 2003 01:37, [EMAIL PROTECTED] a écrit : > on Mandrake 9.1, pgAdmin III 1.0.1 binary distribution (rpm). > SSL combobox in connection window is empty :( Sorry, the SSL combobox and a display problem are fixed in CVS head only. I will update the snapshots today. When the snapsh

[pgadmin-support] connection SSL combobox empty

2003-10-17 Thread listes
on Mandrake 9.1, pgAdmin III 1.0.1 binary distribution (rpm). SSL combobox in connection window is empty :( Lafriks ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [E

Re: [pgadmin-support] connection dropping

2003-10-16 Thread Andrae Muys
bill wrote: Thanks for the offer. I am NAT'd behind a D-Link router connected to the cable modem. I am on the Comcast network. I have noticed occasionally that my SSH connections will die off even though I have putty set to do 60 second keep-alives (I'm assuming that it really is). It usually i

Re: [pgadmin-support] connection dropping

2003-10-16 Thread bill
Thanks for the offer. I am NAT'd behind a D-Link router connected to the cable modem. I am on the Comcast network. I have noticed occasionally that my SSH connections will die off even though I have putty set to do 60 second keep-alives (I'm assuming that it really is). It usually isn't a proble

Re: [pgadmin-support] connection dropping

2003-10-16 Thread James M Doherty PGADMIN
Also, if you use an SSH tunnel you can get around the timeout issue... Jim - Original Message - From: <[EMAIL PROTECTED]> To: "bill" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 11:31 AM Subject: Re: [pgadmin-support] con

Re: [pgadmin-support] connection dropping

2003-10-16 Thread James M Doherty PGADMIN
will be dropped by the firewall, this is usually around 120 seconds. Jim - Original Message - From: <[EMAIL PROTECTED]> To: "bill" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 11:31 AM Subject: Re: [pgadmin-support] connection drop

Re: [pgadmin-support] connection dropping

2003-10-16 Thread fmonkey
> Hello, > I love pgAdmin III. I use it when working at home. I'm stuck with II at > work since my machine is W98, although it (II)has a feature I prefer > over III. Anyway, here on the homefront, I'm connected via high-speed > cable connection (1.5 meg). I get excellent performance, however, I fin

[pgadmin-support] connection dropping

2003-10-16 Thread bill
Hello, I love pgAdmin III. I use it when working at home. I'm stuck with II at work since my machine is W98, although it (II)has a feature I prefer over III. Anyway, here on the homefront, I'm connected via high-speed cable connection (1.5 meg). I get excellent performance, however, I find that

Re: [pgadmin-support] Connection

2003-01-22 Thread Dave Page
Can you confirm that PostgreSQL is running with tcp/ip sockets enabled on your server? Regards, Dave. > -Original Message- > From: Jonathan Hemley [mailto:[EMAIL PROTECTED]] > Sent: 22 January 2003 18:04 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Connection >

[pgadmin-support] Connection

2003-01-22 Thread Jonathan Hemley
I'm trying to connect to my Linux box using your tool. I can telnet to it but when I enter the info fo Connect to server, I enter the ip, keep the port at 5432, and enter the password for postgres, I get the error, a large negative number and "could not connect to remote socket". -

[pgadmin-support] Connection ODBC

2003-01-10 Thread Daniel
    Gostaria de saber como o PostgreSQL consegue conectar-se automaticamente com o servidor postmaster sem necessidade de start manual do mesmo;   O que devo fazer ?   Sds. Daniel

Re: [pgadmin-support] Connection ODBC

2003-01-07 Thread Rick Moore
> > Date: 06/01/03 > > I need to connect ASP - (Active Server Pages)to the data base > POSTGRESQL,Is it possible? Yes. > I don't know the connection string,so Ineedthat someone can help me, and > tell me some information about that. I could send you a full example (of course the database

[pgadmin-support] Connection ODBC

2003-01-07 Thread Daniel
Date: 06/01/03       I need to connect ASP - (Active Server Pages) to the data base POSTGRESQL,  Is it possible?     I don't know the connection string, so I need that someone can help me, and tell me some information about that.     Are there some more special thing to do?   Thanks for al

Re: [pgadmin-support] Connection & Crash Problem From Domain Users

2002-11-25 Thread Dave Page
> -Original Message- > From: Çagil Seker [mailto:[EMAIL PROTECTED]] > Sent: 25 November 2002 12:28 > To: Dave Page > Cc: PGAdmin-Support-List (E-mail) > Subject: RE: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > the ser

Re: [pgadmin-support] Connection & Crash Problem From Domain Users

2002-11-25 Thread Çagil Seker
: PGAdmin-Support-List (E-mail) > Subject: Re: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > As far as I can see there is nothing wrong here either. Bear > in mind that with full Debug turned on, things will be > *significantly* slower because n

Re: [pgadmin-support] Connection & Crash Problem From Domain Users

2002-11-25 Thread Dave Page
Seker [mailto:[EMAIL PROTECTED]] > Sent: 25 November 2002 10:49 > To: Dave Page > Cc: PGAdmin-Support-List (E-mail) > Subject: RE: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > I opened the pgAdmin2. Change the log file to > ...CRASH...so

Re: [pgadmin-support] Connection & Crash Problem From Domain Users

2002-11-25 Thread Dave Page
> -Original Message- > From: Çagil Seker [mailto:[EMAIL PROTECTED]] > Sent: 23 November 2002 11:12 > To: Dave Page > Cc: PGAdmin-Support-List (E-mail) > Subject: RE: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > I am sendi

Re: [pgadmin-support] Connection & Crash Problem From Domain Users

2002-11-21 Thread Dave Page
> -Original Message- > From: Çagil Seker [mailto:[EMAIL PROTECTED]] > Sent: 21 November 2002 17:27 > To: PGAdmin-Support-List (E-mail) > Subject: [pgadmin-support] Connection & Crash Problem From > Domain Users > > > Ok. now I have a new problem!

[pgadmin-support] Connection & Crash Problem From Domain Users

2002-11-21 Thread Çağıl Şeker
Ok. now I have a new problem! I can use pgadmin without any problem under the local W2K accounts POSTGRES and TESTUSER. But if I run pgadmin under the domain W2K account MYDOMAIN/CAGILS it connects (and is very slowly) and then when I try to reach the public database object which is created defa

[pgadmin-support] Connection Error

2002-08-17 Thread Ludwig Lim
Hi: I've been using PGAdmin for quite a while, and its a good, easy to use powerful tool. Today while trying to connect to the PostgreSQL database, I encountered the following error message: An error has occured on PGAdmin II : frmConnect.CmdConnect_click : Number : -2147220999 Descr