De: Melvin Davidson [mailto:melvin6...@yahoo.com]
Enviado el: jueves, 19 de enero de 2017 12:16 p. m.
Para: Fernando
Asunto: Re: [pgadmin-support] Server Status
I am not PgAdmin III support, but please note that the latest version is
PgAdmin III 1.22.0.
Try downloading and installing that version
Hello List!,
I am trying to query server status in PgAdmin III 1.14.3 on Windows 10 and
postgres database 9.1 version
and I have this error message "invalid byte sequence for encoding "UTF8"
I attached an image, somebody have some idea?
How could resolve this problem?
Regards,
Fernando
Hi folks,
When I try to open server status in pgadmin 1.18 I get the following error messages:
An error has occurred ERROR: path must be in or below the current directory
CONTEXT: SQL function pg_file_length statement 1
An error has occurred column not found in pgset:filename
An e
On Wed, Oct 12, 2016 at 4:38 AM, Oscar wrote:
> Thank you for the big job you have put in to PGAdmin 4. I'v already
> experienced big improvements in stability compared to PGAdmin 3.
>
> I'm however missing, or just unable to find, the "Server status" that was
> accessed under Tools in 3. Parts o
Thank you for the big job you have put in to PGAdmin 4. I'v already
experienced big improvements in stability compared to PGAdmin 3.
I'm however missing, or just unable to find, the "Server status" that was
accessed under Tools in 3. Parts of it is in the dashboard but not with the
same good ovevi
Very new user.
Problem: Server Status has no data in Activity, Locks, Prepared
Transactions windows. 100% repeatable though restarts, etc.
Ubuntu 15.10
PostgreSQL 9.4 and 9.5
pgadminIII 1.20 and 1.22
logfile window does work, per proper log set up in postgresql.conf
SQL Editor query: SELECT * F
Hi,
On Thu, Dec 19, 2013 at 1:26 AM, Campbell, Lance wrote:
> pgAdmin 3 1.18.1
>
> PostgreSQL 9.2
>
> I am having issues with a query getting “stuck” while doing updates. So I
> went to Server Status in pgAdmin. I found the query was highlighted in
> dark orange. When a query appears to get
pgAdmin 3 1.18.1
PostgreSQL 9.2
I am having issues with a query getting "stuck" while doing updates. So I went
to Server Status in pgAdmin. I found the query was highlighted in dark orange.
When a query appears to get hung up and won't finish what steps should I take
to figure out what is hap
> Chris Campbell-14 wrote
> > My question is, where is the Application name column pulling its data
> > from?
>
> http://www.postgresql.org/docs/9.2/interactive/runtime-config-
> logging.html
>
> Section 18.8.3
>
> "application_name"
>
> Issue a:
>
> SET application_name = 'my_application';
>
Chris Campbell-14 wrote
> My question is, where is the Application name column pulling its data
> from?
http://www.postgresql.org/docs/9.2/interactive/runtime-config-logging.html
Section 18.8.3
"application_name"
Issue a:
SET application_name = 'my_application';
command upon establishing a c
Hi Group,
I think I've asked this question before a long time ago but I'm hoping to get a
different answer this time. :D
In pgAdmin III - 1.16.1, on the Server Status screen, the Activity grid lists
current database connections.
The Application name column very clearly lists pgAdmin III connec
On Thu, 2013-01-03 at 16:11 +, Campbell, Lance wrote:
> PostgreSQL 9.2.2
> pgAdmin 1.16.1
> pgAdmin > Tools > Server Status
>
> When viewing the Server Status window I notice that my queries look like this:
>
> SELECT * FROM tablex WHERE id=$1
>
> How can I display the full query without the
PostgreSQL 9.2.2
pgAdmin 1.16.1
pgAdmin > Tools > Server Status
When viewing the Server Status window I notice that my queries look like this:
SELECT * FROM tablex WHERE id=$1
How can I display the full query without the $1?
Example of what I would like to see:
SELECT * FROM tablex where id=75
On Sun, 2012-09-16 at 07:26 -0600, Doug Easterbrook wrote:
> just to add to this change in behaviour
>
> if I use pgadmin 1.16 against a 9.1.5 database, the current_query goes blank
> when the query finished. So the behaviour clearly changes when it is
> pgadmin against a 9.2 database.
>
>
>
just to add to this change in behaviour
if I use pgadmin 1.16 against a 9.1.5 database, the current_query goes blank
when the query finished. So the behaviour clearly changes when it is pgadmin
against a 9.2 database.
just to make sure, I had a look at
http://www.postgresql.org/docs/9.2/sta
hi There:
I just updated from postgres 9.1.5 to postgres 9.2 which comes with pgAmdin
1.16. Platform is OS-X 10.8.1 that I ran into this issue, so I don't know if
it is universal or not.
Once I connect to a server and go to tools->Server Status to watch the commands
executing or the look at
On Tue, 2012-03-20 at 12:53 -0700, MattK wrote:
> With reduced logging, I still get regular periods of unresponsiveness, even
> when Don't Refresh is set in the monitor window.
>
> Does PgAdmin look at all logs in pg_log, or only the current one?
>
Only the selected one in the combobox.
> Is t
issue?
>
> From: MattK
>To: Dave Page
>Cc: "pgadmin-support@postgresql.org"
>Sent: Tuesday, March 20, 2012 12:54 PM
>Subject: Re: [pgadmin-support] Server status hanging on OS X
>
>
>Very likely. I had some large log files (>1GB). Setting t
>Sent: Tuesday, March 20, 2012 4:47 AM
>Subject: Re: [pgadmin-support] Server status hanging on OS X
>
>On Mon, Mar 19, 2012 at 7:26 PM, MattK wrote:
>> I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not
>> happen on all of my Postgres instances, the one
On Mon, Mar 19, 2012 at 7:26 PM, MattK wrote:
> I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not
> happen on all of my Postgres instances, the one I am trying to actively
> monitor that exhibits the problem is through the ssh port forward.
>
> Running ssh -v -L 5433::5432 @
: channel 5: window 1997018 sent adjust 100134
>
> From: MattK
>To: "pgadmin-support@postgresql.org"
>Sent: Saturday, March 17, 2012 2:06 PM
>Subject: [pgadmin-support] Server status hanging on OS X
>
>
>When connecting to a v8.
Le 17/03/2012 19:06, MattK a écrit :
When connecting to a v8.4.9 server on with PgAdmin v1.14.2 on OS X (SL
and Lion) and launching the Server Status window, PgAdmin displays the
status window with highlighted process info, but then the entire
application becomes unresponsive, and shows as not re
When connecting to a v8.4.9 server on with PgAdmin v1.14.2 on OS X (SL and
Lion) and launching the Server Status window, PgAdmin displays the status
window with highlighted process info, but then the entire application becomes
unresponsive, and shows as not responding in the Mac activity monitor
Le 21/12/2010 21:20, Melvin Davidson a écrit :
> PgAdmin v1.12
>
> I noticed that while viewing the Server Status in PgAdmin, the colors change
> for the various processes.
>
> Where is it documented what the significance / meaning of each color is?
>
Go in File/Options, tab Colours. There is
PgAdmin v1.12
I noticed that while viewing the Server Status in PgAdmin, the colors change
for the various processes.
Where is it documented what the significance / meaning of each color is?
Melvin Davidson
Doug,
First off, have you considered the greenplum forums for these sorts of
questions?
> 1.What permissions are required to use the server status
Superuser. Since you get to see other people's queries.
> 2. Is there any workaround if that permission is superuser.
Have a superus
Hi,
We're getting to change the status on our Greenplum/Postgres data warehouse to
a production environment,
As part of that I've lost my superuser privileges. So I'm no longer able to
see the details of the workload on the server,
But it's very helpful. I want it.
1.What permissions
27 matches
Mail list logo
