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
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 connect to our database and use the store
password option. If postgres is no
al message Subject: [ADMIN] PGadmin PostgresSQL From: Tim Dons To: [email protected] CC: 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 connection drops after several minutes. We think that th
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
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 connection drops after several minutes.
We think that the firewall is the problem, but we don't know how to
change the right settings in the firewa
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
Dear Sirs
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
Regards
Adrian Heath
*TrackTrans e-POD*
web: http://www.tracktrans.c
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
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
Hello,
So I plan on deploying a Postgres DB in an military project. On our admin end
we are using the tool to help set up the database for delivery. Now the problem
comes once the system is delivered. The database is used to record all the
system messages for easy retrieval. This feature is rar
On Fri, Oct 30, 2009 at 1:20 PM, David Lazar
wrote:
> Hi,
>
> Preferences for Snow Leopard for me match your advice Mr. Page. Full
> Keyboard Access, All Controls not sure what to try now... sure would be
> sweet to get that cycling option with the KB...
It works fine for me if I turn on all
Hi,
Preferences for Snow Leopard for me match your advice Mr. Page. Full
Keyboard Access, All Controls not sure what to try now... sure would be
sweet to get that cycling option with the KB...
Thanks!
On Fri, Oct 30, 2009 at 4:59 AM, Dave Page wrote:
> On Fri, Oct 30, 2009 at 8:00 AM,
On Fri, Oct 30, 2009 at 8:00 AM, Guillaume Lelarge
wrote:
> 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... wh
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
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... but nothing cycles.. I have
to use the Mouse (eeks) to cycle to the false...
I
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
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,
I've ran the pgagent.sql script against my database. I've started the
pgagent as you can see...
501 3107 1219 0 0:00.06 ttys0000:00.12 pgagent -f -l 2
host=localhost dbname=mydb user=myuser
pgagent output shows...
laptop:~ ryoung$ pgagent -f -l 2 host=localhost dbname=mydb user=myus
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
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
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
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...
- Jim
Hi,
I wonder why pgAdmin's query tool can't process the COPY commands generated by
a BACKUP (pg_dump) in plain text dumps (COPY table (column1, column2) FROM
stdin). Is it just that it's from standard input? Is there a way to make it
work?
Thank you very much,
Peter
--
GMX startet ShortView
Any one knows what it takes to change the colors used for the columns
in regards to table editing/viewing?
I have GTK set to a light foreground on a dark background theme and
it is causing display problems. pgAdmin is using the default text
color for the theme, but using white for the back ground
> 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
"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
Hi List,
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 Editor to change the time zone in
postgresql.
Hi, all.
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 tool
and program hang.
---(end of broa
"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
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
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
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
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
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)
"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
Hello everybody,
I have a problem when I try to backup a table from inside PgAdmin.
If I select a table and choose to backup it, I get the following result :
C:\Programmi\pgAdmin III\1.6\pg_dump.exe -i -h pgsvil.manord.com -p 5432 -U
user -F c -v -f "C:\collezioni.backup" -t collezioni -n anam
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
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
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
I am experiencing pgAdmin (windows xp) crash whenever I try to connect to the
postgresql server (type password and hit enter). It started after installing
the new 8.2 version it didn't do it with the earlier versions. What do I have
wrong?
Thanks
---(end of broadcast)---
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_
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)
I have a postgresql database at the server, with firewall protected. And I want
to access the database remotely using pgadmin on the client side. I have
configured the postgre configuration file in such way that the client can
access the database remotely using pgadmin, but when I turn on the fi
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
I see there are rpms for pgAdmin v1.4.3 on rhel4:
http://www.postgresql.org/ftp/pgadmin3/release/v1.4.3/rhel-4/rpms/
The install chokes on:
[root pgadmin3]# rpm -Uvh pgadmin3-1.4.3-1.i686.rpm
error: Failed dependencies:
libpq.so.3 is needed by pgadmin3-1.4.3-1.i686
postgresql is
@postgresql.org;
postgresql-l; [EMAIL PROTECTED]
Subject: [ADMIN] PGAdmin
"Jobs"
Please assist me in implementing this for the first time?
I have installed Postgres 8.1.4 on my laptop, including Admin, then
accessed the database "postgres" from PGAdmin 1.4.2 and run the
&qu
Please assist me in implementing this for the first time?
I have installed Postgres 8.1.4 on my laptop, including Admin, then accessed the database "postgres" from PGAdmin 1.4.2 and run the "pgagent.sql" script tp populate the database with the following result:-
NOTICE: CREATE TABLE / PRIMARY
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
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
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 command line as
long as postgres approves that access. Is there a way to bring that power
Hi,
If I do a vacuum of my database PgAdmin 1.4.0. Beta 3 does 20-50 % CPOU
load on a dual processor Opteron.
Is that normal?
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: [EMAIL PROTECTED]
web: www.as
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;
[email protected]: Re: [pgadmin-hackers] pgAd
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)?)$
In-time for PostgreSQL 8.1 gold, The pgAdmin Developer Team will release
pgAdmin III V1.4, which has a new Guru hint feature that tries to give
users helpful hints on typical beginner's pitfalls.
The current set of hints is at
http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/trunk/pgadmin3/docs/en_US
Platform: Windows XP/Cygwin
PostgreSQL version: 7.4
PgAdmin version: 1.3.0 (Sep 15 2005)
Problems/Suggestions:
1. pgAdmin hangs when I view the details of a newly created job (without creating a step or a schedule yet)
2. When I do create a job, a step and a schedule at the same time, I get:
ER
Hi, I have been working with pgadmin1.2.2 and database postgres 7.3.2, and
works ok. But I installed a database 7.4.6 and if connect it gives de
following error, anyway connects but when I try to do something gives
error again.
(Embedded image moved to file: pic19912.jpg)
On the other h
Hi,
where could I
download pgAdmin II for Win32?
Thanx
Tomas
Kratochvil
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
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.
@postgresql.orgSubject: [ADMIN] Pgadmin II works with
postgre 7.4.7?
Hi,
I made an update from 7.4.2 to 7.4.7 and pgadmin
II does not connect anymore. The error message is: "The database does not
exist on the server or user authentication failed.". The settings are good, I
c
Hi,
I made an update from 7.4.2 to 7.4.7 and pgadmin II
does not connect anymore. The error message is: "The database does not exist on
the server or user authentication failed.". The settings are good, I can connect
with pgadmin III without no problem.
Do you know also any other postgre
Does anyone know if the current versions of pgAdmin III posted at the download
sites work OK
under Slackware 10.0 ? They say they are for 9.0 / 9.1
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello pgsql-admin,
I have PostgreSQL 7.3.3 (build 2tr) installed on Trustix Secure Linux 2.0
and pgAdmin III v. 1.1.0 (Mar 17 2004), win32 binary package (running under Windows XP)
When I'm using the special names for my tables or columns, like "user", "time" etc.,
(PGSQL keywords), pgAdmin does
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
> > 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
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
How do I uninstall pgAdmin III?
Please help
Regards,
Ganesan
> -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.
>
>
>
> -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.
>
>
>
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,
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
I just finished upgrading from FreeBSD 4.6 to 4.8RC and I'm trying to do some things
with pgAdmin II which are giving me problems.
I remember creating a db called taxcal and it's listed there. However, I don't
remember creating a db called pgsql.
Is this a db that the postgresql needs or was it
System
Windows 2000 Pro.
Postgresql 7.3.1
Apache 2.0.43
cygwin 1.3.18.1
pgAdminII 1.4.12
I got "almost" everything working, (create database/table with cygwin)
now here's problem with pgAdmin II...
Launched pgAdminII, onnected to localhost, through port 5432.
It display the database and login
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
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
Hello everyone,i am having problems to connect to my
postgres server using pgadmin II:
II:frmConnect.cmdConnect_Click: -2147467259 - Could not connect to the server;Could
not connect to remote socket.
i have been surfing the list and followed the instructions in the following link
http://archi
PROTECTED]Subject: [ADMIN] pgAdmin
cannot view tables
Hello,
We're trying to access a database
using pgAdmin II. The database is installed on a Linux
server (Red Hat 7.3 PostgreSQL). PgAdmin II
is installed on Windows 2000 Professional. PgAdmin II
shows the database along
Hello,
We’re trying to access a database using pgAdmin II. The
database is installed on a Linux server (Red Hat 7.3 PostgreSQL). PgAdmin II is
installed on Windows 2000 Professional.
PgAdmin II shows the database along with
Languages and Schemas. None of the
other database features
Hi All,
Don't know if anyone else has had this problem (I'm hoping someone else has
had this problem:)
If I create a second or third schema (PG7.3) in PgAdminII and then create a
view or table in the new schema and attempt to view the data the following
message results:
22/11/2002 07:51:05 - Err
> -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
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
> -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
> 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
We want to install the client at Windows
machine. We had downloaded the pgadmin and installed in in windows2000
machine through windows installer. But we could not configure the DSN and
get going. kindly help by pointing further documentation
Regards,
T.G.Sekhar,
Raghav Infotech Limite
I am using pgAdmin v7.0.1. And in the inicialization, I found the
error:
Error No: 3706Error Description: determined provider not foundError
Source: ADODB.ConnectionDLL Error Code: 0
if somebody know how I can resolv de problem above or if somebody know
where I can find tutorial about ho
85 matches
Mail list logo