Re: [ADMIN] pgAdmin forgets password on "could not connect to server" error

2013-10-02 Thread Walter Hurry
On Tue, 01 Oct 2013 08:17:37 -0600, Andrew Swartzendruber wrote: > Would it be possible to prevent the system from forgetting the stored > password when pgAdmin fails to connect in a future release or have an > option that would prevent forgetting of passwords? > > I use pgAdmin 1.16 or 1.18 to c

Re: [ADMIN] PGadmin PostgresSQL

2012-03-31 Thread Scott Whitney
I dealt with this issue for years. It's not a pgadmin issue. In my case I had ipchains messing with me then iptables. Eventually Cisco. Each time I've moved to a new firewall, I have to re-solve this issue. Unless others are interested, take this offline and email me. Original message -

Re: [ADMIN] PGadmin PostgresSQL

2012-03-30 Thread Dick Visser
What do you mean by 'uploading databases'? I.e. what commands do you issue? Dick Sent from my Iphone On 31 mrt. 2012, at 03:09, Tim Dons wrote: Dear PGAdmin support, We have some troubles with uploading databases to a server of a client on the internet. If we upload the database the conn

Re: [ADMIN] pgAdmin 1.14 backup globals calls pg_dump.exe not pg_dumpall.exe (included pgSQLl 9.1 Windows 32 binary

2011-09-12 Thread Guillaume Lelarge
Hi, On Mon, 2011-09-12 at 15:09 +0100, Adrian Heath wrote: > [...] > pgAdmin 1.14 REL:1_14_0 (build included with official postgresql 9.1 MS > Windows 32 binary) > > Selecting "backup globals" fails with "illegal option --global-only" as > it runs pg_dump.exe instead of pg_dumpall.exe > You'r

Re: [ADMIN] pgadmin user access control features

2011-01-04 Thread Mark Felder
On Tue, 04 Jan 2011 11:04:56 -0600, Dan Sabin wrote: The two options are to give them a query tool we design so we can restrict their actions (to prevent the database from being screwed up). If their user still has access to doing other things it might be possible for that data to be mod

Re: [ADMIN] pgadmin user access control features

2011-01-04 Thread Kevin Grittner
Dan Sabin wrote: > In order to do this the client needs an interface to access the > database. The two options are to give them a query tool we design > so we can restrict their actions (to prevent the database from > being screwed up). The other option would be to restrict their > access in the

Re: [ADMIN] pgAdmin 1.10, OSX 10.6 problem

2009-10-30 Thread Guillaume Lelarge
Le vendredi 30 octobre 2009 à 02:37:04, David Lazar a écrit : > Hi, > > On Linux version of pgAdmin, in an edit grid, with a boolean column, I > could hammer the space bar key and cycle through True, False and the other > one... whatever... > > With OSX version if I hit spacebar I get True... b

Re: [ADMIN] pgadmin not processing scheduled jobs

2008-10-24 Thread Scott Marlowe
On Fri, Oct 24, 2008 at 3:00 PM, Robert Young <[EMAIL PROTECTED]> wrote: > I've solved the issue. pgagent.pga_job.jobhostagent must be blank. Thanks > to this link http://forums.enterprisedb.com/posts/list/1419.page > > Anyway, the docs say ... "optionally the hostname of a specific machine > run

Re: [ADMIN] pgadmin not processing scheduled jobs

2008-10-24 Thread Robert Young
I've solved the issue. pgagent.pga_job.jobhostagent must be blank. Thanks to this link http://forums.enterprisedb.com/posts/list/1419.page Anyway, the docs say ... "optionally the hostname of a specific machine running pgAgent, if this job should only run on that specific server. If left empty,

Re: [ADMIN] pgAdmin III

2008-07-31 Thread Johann Spies
On Thu, Jul 31, 2008 at 06:02:05AM -0500, Jim Toth wrote: > Not explicitly, are there separate installs for those? > Yes Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "Have not I commanded thee? Be strong and of a good

Re: [ADMIN] pgAdmin III

2008-07-31 Thread Jim Toth
Not explicitly, are there separate installs for those? On Thu, Jul 31, 2008 at 2:19 AM, Johann Spies <[EMAIL PROTECTED]> wrote: > On Wed, Jul 30, 2008 at 09:15:38PM -0500, Jim Toth wrote: > > I've installed PostgreSql 8.3 on Ubuntu 8.04. When I click on the > pgAdmin III > > link, nothing happen

Re: [ADMIN] pgAdmin III

2008-07-31 Thread Johann Spies
On Wed, Jul 30, 2008 at 09:15:38PM -0500, Jim Toth wrote: > I've installed PostgreSql 8.3 on Ubuntu 8.04. When I click on the pgAdmin III > link, nothing happens. I'm a newbie here, any help would be appreciated... Did you install pgadmin3 and pgadmin3-data also? Regards Johann -- Johann Spie

Re: [ADMIN] pgAdmin Crashes After Changing Timezone Setting

2008-03-17 Thread Rommel the iCeMAn
> Can't help you with that, you'll need to report that on the pgadmin > mailing list. Will do. > Did you remove the comment marker (#) from the timezone setting line? Yes I did, which is why it baffles me. Here's what that part of my conf file looks like: # - Locale and Formatting - datestyle

Re: [ADMIN] pgAdmin Crashes After Changing Timezone Setting

2008-03-17 Thread Tom Lane
"Rommel the iCeMAn" <[EMAIL PROTECTED]> writes: > I'm experiencing strange behavior in pgAdmin. I recently noticed that my > PostgreSQL reports a different time to the OS. I checked the time zone > setting and realized it was set to 'Canada/Atlantic'. I tried using > pgAdmin's Backend Configuration

Re: [ADMIN] PgAdmin hang on cancel query

2007-07-19 Thread Ender
"Ender" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm tried to cancel long running query in the PgAdmin. Run query, press > [Cancel query] button and voila. Program stil live but i'm can't run > queries anymore. Run query button still disabled. Close query tool, open > query

Re: [ADMIN] [pgadmin-support] Motivations for PostgreSQL

2007-04-11 Thread Benjamin Krajmalnik
2:22 PM To: Ezequias Rodrigues da Rocha; Postgres Subject: Re: [ADMIN] [pgadmin-support] Motivations for PostgreSQL The problem is, this isn't a logical decision they are making. They are only comfortable with Micro$oft and when I mention a database th

Re: [ADMIN] [pgadmin-support] Motivations for PostgreSQL

2007-04-10 Thread Joshua Kramer
Aaron, You might want to probe a little further. Even though you know their reason for wanting SQL Server - "cause it's what they know" - ask them specifically what advantages SQL Server will give them over their current setup. If you know what *they think* their objections are, then you ar

Re: [ADMIN] [pgadmin-support] Motivations for PostgreSQL

2007-04-10 Thread Aaron Bono
The problem is, this isn't a logical decision they are making. They are only comfortable with Micro$oft and when I mention a database they haven't heard of before, they cringe even though I have proven it's ability to serve all their needs for the last year. What it comes down to is that I need

Re: [ADMIN] [pgadmin-support] UNSUBSCRIBE

2007-02-22 Thread Andy Shellam (Mailing Lists)
To all who want unsubscribing, it is best to fill out this form: http://www.postgresql.org/community/lists/subscribe Regards, Andy. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs

Re: [ADMIN] PgAdmin : table backup problem

2007-02-15 Thread Andy Shellam (Mailing Lists)
Tom Lane wrote: "Cassiano, Marco" <[EMAIL PROTECTED]> writes: If I understand well, PgAdmin fails in composing the correct pg_dump command. The switch combination -t collezioni -n anamat doesn't work. The manual says that the -n switch is ignored when -t is used The right (at least, working)

Re: [ADMIN] PgAdmin : table backup problem

2007-02-15 Thread Tom Lane
"Cassiano, Marco" <[EMAIL PROTECTED]> writes: > If I understand well, PgAdmin fails in composing the correct pg_dump command. > The switch combination -t collezioni -n anamat doesn't work. The > manual says that the -n switch is ignored when -t is used > The right (at least, working) syntax seems t

Re: [ADMIN] pgAdmin crashes

2006-12-26 Thread Andy Shellam (Mailing Lists)
As with Bobby, I advise you to post on pgadmin-support. This list is for support with the server administration. You might also want to provide pgadmin-support with details such as your server version, client version, PgAdmin version, platform, steps to reproduce the problem etc. It'll give

Re: [ADMIN] pgAdmin crashes

2006-12-26 Thread Iannsp
Andy Shellam (Mailing Lists) escreveu: Hi Bobby, I'd ask on the pgadmin-support list - PgAdmin's developers live there more-so than here. Regards, Andy Bobby Gontarski wrote: I am experiencing pgAdmin (windows xp) crash whenever I try to connect to the postgresql server (type password and

Re: [ADMIN] pgAdmin crashes

2006-12-26 Thread Andy Shellam (Mailing Lists)
Hi Bobby, I'd ask on the pgadmin-support list - PgAdmin's developers live there more-so than here. Regards, Andy Bobby Gontarski wrote: I am experiencing pgAdmin (windows xp) crash whenever I try to connect to the postgresql server (type password and hit enter). It started after installin

Re: [ADMIN] [pgadmin-support] DB problem

2006-12-26 Thread Harald Armin Massa
Vinayakr, We are using PostgreSQL 7.3 version, installed in linux system. Only DB is getting shut down 3-4 times a day. From my application end I get "Sorry too many clients" error. Maybe you should rise the maximum connections? log_timestamp= true log_directory=pg_log log_filename=%Y-%m-%d_

Re: [ADMIN] pgadmin firewall configuration

2006-12-12 Thread Andy Shellam (Mailing Lists)
No, Pg Admin connects to 5432 as that is PostgreSQL's server port. One popular misconfiguration I've seen is that the connection/traffic is *to* port 5432 on the server, not from port 5432 on the client. So, depending on your firewall you need rule 1 on it's own (if it supports keeping state)

Re: [ADMIN] pgAdmin install?

2006-10-16 Thread Ray Stell
I installed from source, retaining targets wxGTK-* installed from rpm from http://www.postgresql.org/ftp/pgadmin3/release/v1.4.3/rhel-4/rpms/ Seems to run, anyway. On Mon, Oct 16, 2006 at 03:19:49PM -0400, Ray Stell wrote: > I see there are rpms for pgAdmin v1.4.3 on rhel4: > > http://www.postg

Re: [ADMIN] PGAdmin "Jobs"

2006-07-07 Thread Andy Shellam
There is a menu item under Display called “System Objects”.  Enable this, restart PgAdmin.  Then when you connect you’ll have all schemas/objects listed.   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of adey Sent: 07 July 2006 1:26 am To: pgsql-admin@postgresql.o

Re: [ADMIN] pgadmin 1.4 + pgsql 8.1.0

2006-03-22 Thread Peter Eisentraut
Mr. Dan wrote: > Pgadmin is amazing. You can log on with a user account that's been > authenticated through Linux PAM and then run a command like pg_dump > or createdb that you wouldn't have access to run on the linux command > line as long as postgres approves that access. PgAdmin doesn't have a

Re: [ADMIN] pgadmin 1.4 + pgsql 8.1.0

2006-03-22 Thread Bruno Wolff III
On Wed, Mar 22, 2006 at 09:42:54 -0500, "Mr. Dan" <[EMAIL PROTECTED]> wrote: > Hi, > > Pgadmin is amazing. You can log on with a user account that's been > authenticated through Linux PAM and then run a command like pg_dump or > createdb that you wouldn't have access to run on the linux comma

Re: [ADMIN] [pgadmin-hackers] pgAdmin guru hints

2005-10-03 Thread Dave Page
Thanks - fix committed to svn.   Regards, Dave From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bastiaan WakkieSent: 03 October 2005 17:04To: Andreas PflugCc: PostgreSQL-development; pgadmin-hackers; pgsql-admin@postgresql.orgSubject: Re: [pgadmin-hackers] pgAd

Re: [ADMIN] [pgadmin-hackers] pgAdmin guru hints

2005-10-03 Thread Bastiaan Wakkie
I noticed a typo in hints/conn-hba.html The second internal ip adres missed a '.' You're invited to make your comments on the hints: are these correct, is there something missing or misleading? Cheers, -- ^(B(astia{2}n)?)(\s)?(W(ak{2}ie)?)$

Re: [ADMIN] pgadmin

2005-05-11 Thread Scott Marlowe
On Wed, 2005-05-11 at 15:30, Ing. Jhon Carrillo wrote: > I need when the users are conected to pgadmin only have access to > their databases (owners) and not entry to another databases when they > aren't owners. > > thanks. Look here: http://www.postgresql.org/docs/8.0/static/client-authenti

Re: [ADMIN] Pgadmin II works with postgre 7.4.7?

2005-03-15 Thread Wes Williams
Not stand-alone [web-based and required PHP] but phppgadmin works pretty well.   http://phppgadmin.sourceforge.net/ -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Andrei BintintanSent: Tuesday, March 15, 2005 5:50 AMTo: pgsql-admin@postgr

Re: [ADMIN] [pgadmin-support] switching postgres from windows to linux

2004-01-04 Thread vidhya baskaran
Hi, We are using postgres under Cygwin on a win2k server and we would like to move it to a Linux box.   You told to use PsqlODBC driver to establish a connection between a Linux based postgres server and a Windows application.   We have to install psqlODBC driver in win2k server is it right? Do we

Re: [ADMIN] pgAdmin

2003-11-02 Thread Mailing List
> > How do I uninstall pgAdmin III? Please help > pgAdmin is installed on linux redhat 8. If you used rpm (redhat package manager) to install it, you can uninstall it with: rpm -e pgadmin3 Bye, Chris. ---(end of broadcast)--- TIP 2: you can

Re: [ADMIN] pgAdmin

2003-11-02 Thread Ganesan Kanavathy
pgAdmin is installed on linux redhat 8.   Regards, Ganesan   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ganesan Kanavathy Sent: Sunday, November 02, 2003 17:03 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [ADMIN] pgAdmin   How d

Re: [ADMIN] [pgadmin-support] Overloading functions that are used by operators.

2003-07-18 Thread Dave Page
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 10 July 2003 17:07 > To: Dave Page > Cc: Donald Fraser; [ADMIN]; [pgADMIN] > Subject: Re: [ADMIN] [pgadmin-support] Overloading functions > that are used by operators. > > >

Re: [ADMIN] [pgadmin-support] Overloading functions that are used by operators.

2003-07-11 Thread Dave Page
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 10 July 2003 16:38 > To: Dave Page > Cc: Donald Fraser; [ADMIN]; [pgADMIN] > Subject: Re: [ADMIN] [pgadmin-support] Overloading functions > that are used by operators. > > >

Re: [ADMIN] [pgadmin-support] Overloading functions that are used by operators.

2003-07-09 Thread Dave Page
Title: Message Ahh, thanks. Was just looking at that.   Well I always thought you could overload functions in this way, however with your example below, although it creates it OK, PostgreSQL (not pgAdmin) gives the error 'ERROR: There is more than one function named textcat'.   As I said,

Re: [ADMIN] [pgadmin-support] Overloading functions that are used by operators.

2003-07-09 Thread Dave Page
Title: Message   -Original Message-From: Donald Fraser [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 21:00To: [ADMIN]Cc: [pgADMIN]Subject: [pgadmin-support] Overloading functions that are used by operators. I have a question regarding operators which are causing proble

Re: [ADMIN] Pgadmin II

2003-01-03 Thread Hernan Salvarezza
Joost: I am running Psyche and i can access to the local database template1 without any problem.. The problem comes into play when i try to establish a tcp/ip connection from windows. I also installed iodbc like in the howto,the only problem is that i could not install libiodbc-devel I di

Re: [ADMIN] Pgadmin II

2003-01-03 Thread Joost Kraaijeveld
Did you start postmaster with -i ? Joost Kraaijeveld Gogis Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 email: [EMAIL PROTECTED] web: www.gogis.nl ---(end of broadcast)--- TIP 3: if posting/reading through U

Re: [ADMIN] pgAdmin cannot view tables

2002-12-31 Thread Jie Liang
try latest version 1.4.12, if your pg is pre 7.3 then schema public is dummy one.   click public schma, you should see tables.     good luck.   Jie Liang -Original Message-From: Chris White [mailto:[EMAIL PROTECTED]]Sent: Monday, December 30, 2002 4:24 PMTo: [EMAIL PROTECTE

Re: [ADMIN] [pgadmin-support] Cache lookup error

2002-06-06 Thread Dave Page
> -Original Message- > From: Marc Mitchell [mailto:[EMAIL PROTECTED]] > Sent: 05 June 2002 23:44 > To: Dave Page; Ramya Asokan; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: [ADMIN] [pgadmin-support] Cache lookup error > > > I've been experien

Re: [ADMIN] [pgadmin-support] Cache lookup error

2002-06-05 Thread Marc Mitchell
AIL PROTECTED] - Original Message - From: "Dave Page" <[EMAIL PROTECTED]> To: "Ramya Asokan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, May 24, 2002 4:27 PM Subject: Re: [ADMIN] [pgadmin-support] Cache lookup error &g

Re: [ADMIN] [pgadmin-support] Cache lookup error

2002-05-27 Thread Dave Page
> -Original Message- > From: Ramya Asokan [mailto:[EMAIL PROTECTED]] > Sent: 24 May 2002 21:01 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [pgadmin-support] Cache lookup error > > > Hi, > I created a function and a trigger - I then dropped them and > created the same funct

Re: [ADMIN] [pgadmin-hackers] Hebrew support

2002-02-19 Thread Jean-Michel POURE
> Jean-Michel.. if you are reading, have you had any more thoughts on this? > If we knock up a test app, can you test on any of you machines? We could at > least then allow the pgAdmin user to select the font, and have them > download a suitable one if required. Dear Dave, It is not a problem of