Of carlosinfl .
Sent: 18 June 2013 16:15
To: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Server Instrumentation
On Tue, Jun 18, 2013 at 1:13 AM, Brett Maton
wrote:
> Hi Carlos,
>
> I'm guessing you want the "adminpack" for use with pgadmin.
>
Hi Carlos,
I'm guessing you want the "adminpack" for use with pgadmin.
It's usually bundled in the postgresql92-contrib RPM with EL distros.
As root install the package
# yum install postgresql92-contrib
As postgres
$ psql
postgres=# CREATE EXTENSION adminpack;
CREATE EXTENSION
You can list
Which version are you running?
I use pgAdmin3 v. 1.16.1 on an Air with 4Gb of RAM, OS X 10.7.5 and it works
just fine without any noticeable lag.
From: pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Tim Uckun
Sent: 19 April 2013 01:36
To
pgAdmin v 1.16.1
Windows 7 x64
PostgreSQL v9.4.2
CentOS 6.4
pgAdmin by default when editing a user's account settings seems to set
Account Validity to '1969-12-31 00:00:00+01' if the role is defined as valid
until infinity.
This results in the user not being able to
Hi Dave,
Your absolutly right that the syntax is likely to be incompatible, but you
can get the select statement from the DB some how, I down loaded ADO Query
Tool from this guys site todo on the fly SQL with the Access DB and it
manages to get the SQL statements from views
http://gpoul
Hi Dave,
Thanks for that date fix, I noticed that 'Query Tables' are migrated as
Tables. They should be migrated as 'Views', otherwise the data in them will
just be static. I have been trying to find find out how to get the query
used to create the view ( '\d' command in plsql or describe i
