[Pkg-postgresql-public] Bug#888421: pgadmin3: not supporting pgsql server 10, error reading postgres db
Andre Verwijs
dutch.glory at yahoo.com
Thu Jan 25 11:55:34 UTC 2018
Package: pgadmin3
Version: 1.22.2-3
Severity: important
Tags: upstream
pgadmin3: not supporting pgsql server 10.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WARNING: 12:10:35: Warning: The server you are connecting to is not a version
that is supported by this release of pgAdmin III.
pgAdmin III may not function as expected.
Supported server versions are 8.4 to 9.6.
QUERY : 12:10:38: Set query (localhost:5432): SELECT usecreatedb, usesuper,
CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince,
CASE WHEN usesuper THEN pg_conf_load_time() ELSE NULL END as confloadedsince,
CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE
WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc,
CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as
replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL
END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery() THEN
pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused
FROM pg_user WHERE usename=current_user
ERROR : 12:10:38: Error: ERROR: function pg_last_xlog_receive_location() does
not exist
LINE 1: ...E NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xl...
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
ERROR : 12:10:40: Error: Column not found in pgSet: usecreatedb
ERROR : 12:12:08: Error: Column not found in pgSet: usesuper
ERROR : 12:12:10: Error: Column not found in pgSet: upsince
ERROR : 12:12:10: Error: Column not found in pgSet: confloadedsince
ERROR : 12:12:11: Error: Column not found in pgSet: inrecovery
ERROR : 12:12:11: Error: Column not found in pgSet: replayloc
ERROR : 12:12:11: Error: Column not found in pgSet: receiveloc
ERROR : 12:12:11: Error: Column not found in pgSet: replay_timestamp
ERROR : 12:12:11: Error: Column not found in pgSet: isreplaypaused
assertion fail:
~~~~~~~~~~~~~~~~~
ASSERT INFO:
db/pgSet.cpp(284): assert "col < nCols && col >= 0" failed in GetBool().
BACKTRACE:
[1] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase const&,
wxEvtHandler*, wxEvent&)
[2] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*)
[3] wxEvtHandler::TryHereOnly(wxEvent&)
[4] wxEvtHandler::DoTryChain(wxEvent&)
[5] wxEvtHandler::ProcessEvent(wxEvent&)
[6] wxWindowBase::TryAfter(wxEvent&)
[7] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&)
[8] wxGenericTreeCtrl::OnChar(wxKeyEvent&)
[9] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase const&,
wxEvtHandler*, wxEvent&)
[10] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*)
[11] wxEvtHandler::TryHereOnly(wxEvent&)
[12] wxEvtHandler::ProcessEventLocally(wxEvent&)
[13] wxEvtHandler::ProcessEvent(wxEvent&)
[14] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&)
[15] wxEvtHandler::SafelyProcessEvent(wxEvent&)
[16] g_closure_invoke
[17] g_signal_emit_valist
[18] g_signal_emit
[19] gtk_window_propagate_key_event
[20] g_closure_invoke
[21] g_signal_emit_valist
[22] g_signal_emit
[23] gtk_propagate_event
[24] gtk_main_do_event
[25] g_main_context_dispatch
[26] g_main_loop_run
[27] gtk_main
[28] wxGUIEventLoop::DoRun()
[29] wxEventLoopBase::Run()
[30] wxAppConsoleBase::MainLoop()
[31] wxEntry(int&, wchar_t**)
[32] __libc_start_main
log files added as attachment
...
-- System Information:
Debian Release: buster/sid
APT prefers testing-debug
APT policy: (500, 'testing-debug'), (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 4.14.0-3-amd64 (SMP w/2 CPU cores)
Locale: LANG=nl_NL.UTF-8, LC_CTYPE=nl_NL.UTF-8 (charmap=UTF-8), LANGUAGE=nl (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages pgadmin3 depends on:
ii libc6 2.26-4
ii libgcc1 1:7.2.0-19
ii libgcrypt20 1.8.1-4
ii libpq5 10.1-3
ii libstdc++6 7.2.0-19
ii libwxbase3.0-0v5 3.0.3.1+dfsg2-1
ii libwxgtk3.0-0v5 3.0.3.1+dfsg2-1
ii libxml2 2.9.4+dfsg1-6.1
ii libxslt1.1 1.1.29-5
ii pgadmin3-data 1.22.2-3
Versions of packages pgadmin3 recommends:
ii pgagent 3.4.1-5.pgdg90+1
ii postgresql-client 10+189.pgdg90+1
ii postgresql-client-10 [postgresql-client] 10.1-3
Versions of packages pgadmin3 suggests:
pn postgresql-contrib <none>
-- no debconf information
-------------- next part --------------
ASSERT INFO:
db/pgSet.cpp(284): assert "col < nCols && col >= 0" failed in GetBool().
BACKTRACE:
[1] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&)
[2] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*)
[3] wxEvtHandler::TryHereOnly(wxEvent&)
[4] wxEvtHandler::DoTryChain(wxEvent&)
[5] wxEvtHandler::ProcessEvent(wxEvent&)
[6] wxWindowBase::TryAfter(wxEvent&)
[7] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&)
[8] wxGenericTreeCtrl::OnChar(wxKeyEvent&)
[9] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&)
[10] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*)
[11] wxEvtHandler::TryHereOnly(wxEvent&)
[12] wxEvtHandler::ProcessEventLocally(wxEvent&)
[13] wxEvtHandler::ProcessEvent(wxEvent&)
[14] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&)
[15] wxEvtHandler::SafelyProcessEvent(wxEvent&)
[16] g_closure_invoke
[17] g_signal_emit_valist
[18] g_signal_emit
[19] gtk_window_propagate_key_event
[20] g_closure_invoke
[21] g_signal_emit_valist
[22] g_signal_emit
[23] gtk_propagate_event
[24] gtk_main_do_event
[25] g_main_context_dispatch
[26] g_main_loop_run
[27] gtk_main
[28] wxGUIEventLoop::DoRun()
[29] wxEventLoopBase::Run()
[30] wxAppConsoleBase::MainLoop()
[31] wxEntry(int&, wchar_t**)
[32] __libc_start_main
-------------- next part --------------
WARNING: 12:10:35: Warning: The server you are connecting to is not a version that is supported by this release of pgAdmin III.
pgAdmin III may not function as expected.
Supported server versions are 8.4 to 9.6.
QUERY : 12:10:38: Set query (localhost:5432): SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince, CASE WHEN usesuper THEN pg_conf_load_time() ELSE NULL END as confloadedsince, CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc, CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused
FROM pg_user WHERE usename=current_user
ERROR : 12:10:38: Error: ERROR: function pg_last_xlog_receive_location() does not exist
LINE 1: ...E NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xl...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
ERROR : 12:10:40: Error: Column not found in pgSet: usecreatedb
ERROR : 12:12:08: Error: Column not found in pgSet: usesuper
ERROR : 12:12:10: Error: Column not found in pgSet: upsince
ERROR : 12:12:10: Error: Column not found in pgSet: confloadedsince
ERROR : 12:12:11: Error: Column not found in pgSet: inrecovery
ERROR : 12:12:11: Error: Column not found in pgSet: replayloc
ERROR : 12:12:11: Error: Column not found in pgSet: receiveloc
ERROR : 12:12:11: Error: Column not found in pgSet: replay_timestamp
ERROR : 12:12:11: Error: Column not found in pgSet: isreplaypaused
-------------- next part --------------
INFO : 12:10:30: ##############################################################
INFO : 12:10:30: # pgAdmin III Version 1.22.2 Startup
INFO : 12:10:30: ##############################################################
INFO : 12:10:30: Running a DEBUG build.
INFO : 12:10:30: i18n path : /usr/share/pgadmin3/i18n
INFO : 12:10:30: UI path :
INFO : 12:10:30: Doc path : /usr/share/pgadmin3/docs
INFO : 12:10:30: Branding path : /usr/share/pgadmin3/branding
INFO : 12:10:30: Plugins path : /usr/share/pgadmin3/plugins.d
INFO : 12:10:30: Settings INI : /usr/share/pgadmin3/settings.ini
INFO : 12:10:30: PG pg_dump : /usr/bin/pg_dump
INFO : 12:10:30: PG pg_dumpall : /usr/bin/pg_dumpall
INFO : 12:10:30: PG pg_restore : /usr/bin/pg_restore
INFO : 12:10:30: EDB pg_dump :
INFO : 12:10:30: EDB pg_dumpall:
INFO : 12:10:30: EDB pg_restore:
INFO : 12:10:30: Greenplum pg_dump :
INFO : 12:10:30: Greenplum pg_dumpall:
INFO : 12:10:30: Greenplum pg_restore:
INFO : 12:10:31: Using embedded XRC data.
INFO : 12:10:31: PG Help : http://www.postgresql.org/docs/current/static/
INFO : 12:10:31: EDB Help : http://www.enterprisedb.com/docs/en/current/server/
INFO : 12:10:31: Greenplum Help: http://gpdb.docs.pivotal.io/
INFO : 12:10:31: Slony Help : http://www.slony.info/documentation/
INFO : 12:10:31: Using fontmetrics 8/19, 10 Point
INFO : 12:10:31: Native Description 'Noto Sans 10'
INFO : 12:10:31: Draw size of 'M': w=12, h=19, descent 4, external lead 0.
INFO : 12:10:31: Draw size of 'g': w=8, h=19, descent 4, external lead 0.
INFO : 12:10:31: Draw size of 'Mg': w=20, h=19, descent 4, external lead 0.
INFO : 12:10:31: Loading plugin ini files from /usr/share/pgadmin3/plugins.d
INFO : 12:10:31: Loading plugin utilities from /usr/share/pgadmin3/plugins.d/plugins.ini
INFO : 12:10:31: Adding plugin utility: PSQL Console
INFO : 12:10:31: Command: /usr/bin/x-terminal-emulator -e "$$PGBINDIR/psql" --host "$$HOSTNAME" --port $$PORT --username "$$USERNAME" "$$DATABASE"
INFO : 12:10:31: Description: Open a PSQL console to the current database.
INFO : 12:10:31: Database?: Yes
INFO : 12:10:31: Set Password?: Yes
INFO : 12:10:31: Reloading servers...
INFO : 12:10:31: Loading previously registered servers
INFO : 12:10:31: Loading servers registered on the local machine
INFO : 12:10:31: Displaying properties for Servers Servers
STATUS : 12:10:31: Retrieving details on servers...
STATUS : 12:10:31: Retrieving details on servers... (0 msec)
INFO : 12:10:33: Displaying properties for Server localhost:5432
STATUS : 12:10:33: Retrieving details on server localhost...
STATUS : 12:10:33: Retrieving details on server localhost... (3 msec)
INFO : 12:10:35: Attempting to create a connection object...
INFO : 12:10:35: Using password file /root/.pgpass
STATUS : 12:10:35: Connecting to database...
INFO : 12:10:35: Opening connection with connection string: host='localhost' dbname='postgres' user='postgres' port=5432 application_name='pgAdmin III - Browser'
QUERY : 12:10:35: Scalar query (localhost:5432): SELECT version();
QUERY : 12:10:35: Query result: PostgreSQL 10.1 (Debian 10.1-3) on x86_64-pc-linux-gnu, compiled by gcc (Debian 7.2.0-19) 7.2.0, 64-bit
QUERY : 12:10:35: Set query (localhost:5432): SET DateStyle=ISO;
SET client_min_messages=notice;
SET bytea_output=escape;
SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE datname='postgres'
INFO : 12:10:35: Setting client_encoding to 'UNICODE'
WARNING: 12:10:35: Warning: The server you are connecting to is not a version that is supported by this release of pgAdmin III.
pgAdmin III may not function as expected.
Supported server versions are 8.4 to 9.6.
QUERY : 12:10:38: Set query (localhost:5432): SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince, CASE WHEN usesuper THEN pg_conf_load_time() ELSE NULL END as confloadedsince, CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc, CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused
FROM pg_user WHERE usename=current_user
ERROR : 12:10:38: Error: ERROR: function pg_last_xlog_receive_location() does not exist
LINE 1: ...E NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xl...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
ERROR : 12:10:40: Error: Column not found in pgSet: usecreatedb
ERROR : 12:12:08: Error: Column not found in pgSet: usesuper
ERROR : 12:12:10: Error: Column not found in pgSet: upsince
ERROR : 12:12:10: Error: Column not found in pgSet: confloadedsince
ERROR : 12:12:11: Error: Column not found in pgSet: inrecovery
ERROR : 12:12:11: Error: Column not found in pgSet: replayloc
ERROR : 12:12:11: Error: Column not found in pgSet: receiveloc
ERROR : 12:12:11: Error: Column not found in pgSet: replay_timestamp
ERROR : 12:12:11: Error: Column not found in pgSet: isreplaypaused
QUERY : 12:12:12: Set query (localhost:5432): SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user;
STATUS : 12:12:12: Connecting to database... (01:36 minutes)
STATUS : 12:12:12: Restoring previous environment...
INFO : 12:12:12: pgServer object initialised as required.
INFO : 12:12:12: Adding child object to server localhost:5432
QUERY : 12:12:12: Set query (localhost:5432): SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn, datacl, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
current_setting('default_tablespace') AS default_tablespace,
descr.description
, db.datconnlimit as connectionlimit, db.datcollate as collate, db.datctype as ctype,
(SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=db.oid) AS labels,
(SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=db.oid) AS providers FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
LEFT OUTER JOIN pg_shdescription descr ON (db.oid=descr.objoid AND descr.classoid='pg_database'::regclass)
ORDER BY datname
QUERY : 12:12:12: Set query (localhost:5432): SELECT ts.oid, spcname, pg_catalog.pg_tablespace_location(ts.oid) AS spclocation, spcoptions, pg_get_userbyid(spcowner) as spcuser, spcacl, pg_catalog.shobj_description(oid, 'pg_tablespace') AS description, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=ts.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=ts.oid) AS providers FROM pg_tablespace ts
ORDER BY spcname
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace
WHERE relname='pga_job' AND nspname='pgagent'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT has_table_privilege('pg_authid', 'SELECT')
QUERY : 12:12:12: Query result: t
QUERY : 12:12:12: Set query (localhost:5432): SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description,
(SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=tab.oid) AS labels,
(SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=tab.oid) AS providers FROM pg_authid tab WHERE NOT rolcanlogin ORDER BY rolname
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT has_table_privilege('pg_authid', 'SELECT')
QUERY : 12:12:12: Query result: t
QUERY : 12:12:12: Set query (localhost:5432): SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description,
(SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=tab.oid) AS labels,
(SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=tab.oid) AS providers FROM pg_authid tab WHERE rolcanlogin ORDER BY rolname
QUERY : 12:12:12: Set query (localhost:5432): SELECT setting FROM pg_settings WHERE name IN ('autovacuum', 'track_counts')
INFO : 12:12:12: Displaying properties for Databases Databases
INFO : 12:12:12: Displaying properties for Database opensim
INFO : 12:12:12: Opening connection with connection string: host='localhost' dbname='opensim' user='postgres' port=5432 application_name='pgAdmin III - Browser'
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT version();
QUERY : 12:12:12: Query result: PostgreSQL 10.1 (Debian 10.1-3) on x86_64-pc-linux-gnu, compiled by gcc (Debian 7.2.0-19) 7.2.0, 64-bit
QUERY : 12:12:12: Set query (localhost:5432): SET DateStyle=ISO;
SET client_min_messages=notice;
SET bytea_output=escape;
SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE oid = 16574
INFO : 12:12:12: Setting client_encoding to 'UNICODE'
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT proname FROM pg_proc WHERE proname='pg_get_viewdef' AND proargtypes[1]=16
QUERY : 12:12:12: Query result: pg_get_viewdef
QUERY : 12:12:12: Scalar query (localhost:5432): SHOW search_path
QUERY : 12:12:12: Query result: "$user", opensim, public
QUERY : 12:12:12: Set query (localhost:5432): SELECT nspname, session_user=nspname AS isuser FROM pg_namespace
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='r'
QUERY : 12:12:12: Query result: {Opensim_Tester=a*r*w*d*D*x*t*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='S'
QUERY : 12:12:12: Query result: {Opensim_Tester=r*w*U*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='f'
QUERY : 12:12:12: Query result: {Opensim_Tester=X*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='T'
QUERY : 12:12:12: Query result: {Opensim_Tester=U*/postgres}
INFO : 12:12:12: Adding child object to database opensim
QUERY : 12:12:12: Set query (localhost:5432): SELECT 2 AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl, description, FALSE as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON (des.objoid=nsp.oid AND des.classoid='pg_namespace'::regclass)
WHERE ((nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR
(nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR
(nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) OR
(nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIMIT 1))
) AND nspname NOT LIKE E'pg\\_temp\\_%'AND nspname NOT LIKE E'pg\\_toast_temp\\_%' ORDER BY 1, nspname
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 12703::oid AND defaclobjtype='r'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 12703::oid AND defaclobjtype='S'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 12703::oid AND defaclobjtype='f'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 12703::oid AND defaclobjtype='T'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='r'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='S'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='f'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='T'
INFO : 12:12:12: Query returned no tuples
QUERY : 12:12:12: Set query (localhost:5432): SELECT e.oid, e.xmin, e.evtname AS name, REPLACE(e.evtevent, '_', ' ') AS eventname, pg_catalog.pg_get_userbyid(e.evtowner) AS eventowner, CASE e.evtenabled WHEN 'O' THEN 'enabled' WHEN 'R' THEN 'replica' WHEN 'A' THEN 'always' WHEN 'D' THEN 'disabled' END AS enabled, e.evtfoid AS eventfuncoid, e.evtfoid::regproc AS eventfunname, array_to_string(array(select quote_literal(x) from unnest(evttags) as t(x)), ', ') AS when, pg_catalog.obj_description(e.oid, 'pg_event_trigger') AS comment, p.prosrc AS source, p.pronamespace AS schemaoid, l.lanname AS language FROM pg_event_trigger e
LEFT OUTER JOIN pg_proc p ON p.oid=e.evtfoid
LEFT OUTER JOIN pg_language l ON l.oid=p.prolang
WHERE 1=1 ORDER BY e.evtname
QUERY : 12:12:12: Set query (localhost:5432): select x.oid, pg_get_userbyid(extowner) AS owner, x.extname, n.nspname, x.extrelocatable, x.extversion, e.comment FROM pg_extension x
JOIN pg_namespace n on x.extnamespace=n.oid
join pg_available_extensions() e(name, default_version, comment) ON x.extname=e.name
ORDER BY x.extname
QUERY : 12:12:12: Set query (localhost:5432): SELECT CASE WHEN nspname LIKE E'pg\\_temp\\_%' THEN 1
WHEN (nspname LIKE E'pg\\_%') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl, description, has_schema_privilege(nsp.oid, 'CREATE') as cancreate,
(SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=nsp.oid) AS labels,
(SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=nsp.oid) AS providers
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON (des.objoid=nsp.oid AND des.classoid='pg_namespace'::regclass)
WHERE NOT ((nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR
(nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR
(nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) OR
(nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIMIT 1))
) AND nspname NOT LIKE E'pg\\_temp\\_%'AND nspname NOT LIKE E'pg\\_toast_temp\\_%' ORDER BY 1, nspname
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='r'
QUERY : 12:12:12: Query result: {Opensim_Tester=a*r*w*d*D*x*t*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='S'
QUERY : 12:12:12: Query result: {Opensim_Tester=r*w*U*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='f'
QUERY : 12:12:12: Query result: {Opensim_Tester=X*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='T'
QUERY : 12:12:12: Query result: {Opensim_Tester=U*/postgres}
QUERY : 12:12:12: Set query (localhost:5432): SELECT nsp.oid, substr(nspname, 2) as clustername, nspname, pg_get_userbyid(nspowner) AS namespaceowner, description
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion'
ORDER BY nspname
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT COUNT(*) FROM
(SELECT tgargs from pg_trigger tr
LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
WHERE
tgisinternal
AND co.oid IS NULL
GROUP BY tgargs
HAVING count(1) = 3) AS foo
QUERY : 12:12:12: Query result: 0
QUERY : 12:12:12: Set query (localhost:5432): WITH configs AS (SELECT rolname, unnest(setconfig) AS config FROM pg_db_role_setting s LEFT JOIN pg_roles r ON r.oid=s.setrole WHERE s.setdatabase=16574)
SELECT rolname, split_part(config, '=', 1) AS variable, replace(config, split_part(config, '=', 1) || '=', '') AS value
FROM configs
INFO : 12:12:12: Displaying properties for Schemas Schemas
INFO : 12:12:12: Displaying properties for Schema opensim
INFO : 12:12:12: Adding child object to schema opensim
QUERY : 12:12:12: Set query (localhost:5432): SELECT c.oid, c.collname, c.collcollate, c.collctype,
pg_get_userbyid(c.collowner) as cowner, description
FROM pg_collation c
JOIN pg_namespace n ON n.oid=c.collnamespace
LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid AND des.classoid='pg_collation'::regclass)
WHERE c.collnamespace = 16579::oid
ORDER BY c.collname
QUERY : 12:12:12: Set query (localhost:5432): SELECT d.oid, d.typname as domname, d.typbasetype, format_type(b.oid,NULL) as basetype, pg_get_userbyid(d.typowner) as domainowner,
c.oid AS colloid, c.collname, cn.nspname as collnspname,
d.typlen, d.typtypmod, d.typnotnull, d.typdefault, d.typndims, d.typdelim, bn.nspname as basensp,
description, (SELECT COUNT(1) FROM pg_type t2 WHERE t2.typname=d.typname) > 1 AS domisdup,
(SELECT COUNT(1) FROM pg_type t3 WHERE t3.typname=b.typname) > 1 AS baseisdup,
(SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=d.oid) AS labels,
(SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=d.oid) AS providers
FROM pg_type d
JOIN pg_type b ON b.oid = d.typbasetype
JOIN pg_namespace bn ON bn.oid=b.typnamespace
LEFT OUTER JOIN pg_description des ON (des.objoid=d.oid AND des.classoid='pg_type'::regclass)
LEFT OUTER JOIN pg_collation c ON d.typcollation=c.oid
LEFT OUTER JOIN pg_namespace cn ON c.collnamespace=cn.oid
WHERE d.typtype = 'd' AND d.typnamespace = 16579::oid
ORDER BY d.typname
QUERY : 12:12:12: Set query (localhost:5432): SELECT cfg.oid, cfg.cfgname, pg_get_userbyid(cfg.cfgowner) as cfgowner, cfg.cfgparser, parser.prsname as parsername, description
FROM pg_ts_config cfg
LEFT OUTER JOIN pg_ts_parser parser ON parser.oid=cfg.cfgparser
LEFT OUTER JOIN pg_description des ON (des.objoid=cfg.oid AND des.classoid='pg_ts_config'::regclass)
WHERE cfg.cfgnamespace = 16579::oid
ORDER BY cfg.cfgname
QUERY : 12:12:12: Set query (localhost:5432): SELECT dict.oid, dict.dictname, pg_get_userbyid(dict.dictowner) as dictowner, t.tmplname, dict.dictinitoption, description
FROM pg_ts_dict dict
LEFT OUTER JOIN pg_ts_template t ON t.oid=dict.dicttemplate
LEFT OUTER JOIN pg_description des ON (des.objoid=dict.oid AND des.classoid='pg_ts_dict'::regclass)
WHERE dict.dictnamespace = 16579::oid
ORDER BY dict.dictname
QUERY : 12:12:12: Set query (localhost:5432): SELECT prs.oid, prs.prsname, prs.prsstart, prs.prstoken, prs.prsend, prs.prslextype, prs.prsheadline, description
FROM pg_ts_parser prs
LEFT OUTER JOIN pg_description des ON (des.objoid=prs.oid AND des.classoid='pg_ts_parser'::regclass)
WHERE prs.prsnamespace = 16579::oid
ORDER BY prs.prsname
QUERY : 12:12:12: Set query (localhost:5432): SELECT tmpl.oid, tmpl.tmplname, tmpl.tmplinit, tmpl.tmpllexize, description
FROM pg_ts_template tmpl
LEFT OUTER JOIN pg_description des ON (des.objoid=tmpl.oid AND des.classoid='pg_ts_template'::regclass)
WHERE tmpl.tmplnamespace = 16579::oid
ORDER BY tmpl.tmplname
QUERY : 12:12:12: Set query (localhost:5432): SELECT proname, pronargs, proargtypes[0] AS arg0, proargtypes[1] AS arg1, proargtypes[2] AS arg2
FROM pg_proc
JOIN pg_namespace n ON n.oid=pronamespace
WHERE proname IN ('pg_tablespace_size', 'pg_file_read', 'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend', 'pg_reload_conf', 'pgstattuple', 'pgstatindex')
AND nspname IN ('pg_catalog', 'public')
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclass AND attname = 'proargdefaults'
QUERY : 12:12:12: Query result: 1
QUERY : 12:12:12: Set query (localhost:5432): SELECT pr.oid, pr.xmin, pr.*, pg_get_function_result(pr.oid) AS typname, typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS proargdefaultvals, pronargdefaults, proconfig, pg_get_userbyid(proowner) as funcowner, description,
(SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=pr.oid) AS labels,
(SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=pr.oid) AS providers
FROM pg_proc pr
JOIN pg_type typ ON typ.oid=prorettype
JOIN pg_namespace typns ON typns.oid=typ.typnamespace
JOIN pg_language lng ON lng.oid=prolang
LEFT OUTER JOIN pg_description des ON (des.objoid=pr.oid AND des.classoid='pg_proc'::regclass)
WHERE proisagg = FALSE AND pronamespace = 16579::oid
AND typname NOT IN ('trigger', 'event_trigger')
ORDER BY proname
QUERY : 12:12:12: Set query (localhost:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type
QUERY : 12:12:12: Set query (localhost:5432): SELECT op.oid, op.oprname, pg_get_userbyid(op.oprowner) as opowner, op.oprkind, op.oprcanhash, op.oprcanmerge,
op.oprleft, op.oprright, lt.typname as lefttype, rt.typname as righttype, et.typname as resulttype,
co.oprname as compop, ne.oprname as negop,
op.oprcode as operproc, op.oprjoin as joinproc, op.oprrest as restrproc, description
FROM pg_operator op
LEFT OUTER JOIN pg_type lt ON lt.oid=op.oprleft
LEFT OUTER JOIN pg_type rt ON rt.oid=op.oprright
JOIN pg_type et on et.oid=op.oprresult
LEFT OUTER JOIN pg_operator co ON co.oid=op.oprcom
LEFT OUTER JOIN pg_operator ne ON ne.oid=op.oprnegate
LEFT OUTER JOIN pg_description des ON (des.objoid=op.oid AND des.classoid='pg_operator'::regclass)
WHERE op.oprnamespace = 16579::oid
ORDER BY op.oprname
QUERY : 12:12:12: Set query (localhost:5432): SELECT cl.oid, relname, pg_get_userbyid(relowner) AS seqowner, relacl, description,
(SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=cl.oid) AS labels,
(SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=cl.oid) AS providers
FROM pg_class cl
LEFT OUTER JOIN pg_description des ON (des.objoid=cl.oid AND des.classoid='pg_class'::regclass)
WHERE relkind = 'S' AND relnamespace = 16579::oid
ORDER BY relname
QUERY : 12:12:12: Set query (localhost:5432): SELECT rel.oid, rel.relname, rel.reltablespace AS spcoid, spc.spcname, pg_get_userbyid(rel.relowner) AS relowner, rel.relacl, rel.relhasoids, rel.relhassubclass, rel.reltuples, des.description, con.conname, con.conkey,
EXISTS(select 1 FROM pg_trigger
JOIN pg_proc pt ON pt.oid=tgfoid AND pt.proname='logtrigger'
JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND pc.proname='slonyversion'
WHERE tgrelid=rel.oid) AS isrepl,
(select count(*) FROM pg_trigger
WHERE tgrelid=rel.oid AND tgisinternal = FALSE) AS triggercount
, rel.relpersistence
, substring(array_to_string(rel.reloptions, ',') FROM 'fillfactor=([0-9]*)') AS fillfactor
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS autovacuum_enabled
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS autovacuum_vacuum_threshold
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_vacuum_scale_factor
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS autovacuum_analyze_threshold
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_analyze_scale_factor
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS autovacuum_vacuum_cost_delay
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS autovacuum_vacuum_cost_limit
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS autovacuum_freeze_min_age
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS autovacuum_freeze_max_age
, substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS autovacuum_freeze_table_age
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS toast_autovacuum_enabled
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS toast_autovacuum_vacuum_threshold
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_vacuum_scale_factor
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS toast_autovacuum_analyze_threshold
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_analyze_scale_factor
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS toast_autovacuum_vacuum_cost_delay
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS toast_autovacuum_vacuum_cost_limit
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS toast_autovacuum_freeze_min_age
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS toast_autovacuum_freeze_max_age
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS toast_autovacuum_freeze_table_age
, rel.reloptions AS reloptions, tst.reloptions AS toast_reloptions
, (CASE WHEN rel.reltoastrelid = 0 THEN false ELSE true END) AS hastoasttable
, rel.reloftype, typ.typname
,
(SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=rel.oid AND sl1.objsubid=0) AS labels,
(SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=rel.oid AND sl2.objsubid=0) AS providers FROM pg_class rel
LEFT OUTER JOIN pg_tablespace spc on spc.oid=rel.reltablespace
LEFT OUTER JOIN pg_description des ON (des.objoid=rel.oid AND des.objsubid=0 AND des.classoid='pg_class'::regclass)
LEFT OUTER JOIN pg_constraint con ON con.conrelid=rel.oid AND con.contype='p'
LEFT OUTER JOIN pg_class tst ON tst.oid = rel.reltoastrelid
LEFT JOIN pg_type typ ON rel.reloftype=typ.oid
WHERE rel.relkind IN ('r','s','t') AND rel.relnamespace = 16579::oid
ORDER BY rel.relname
QUERY : 12:12:12: Set query (localhost:5432): SELECT pr.oid, pr.xmin, pr.*, pg_get_function_result(pr.oid) AS typname, typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS proargdefaultvals, pronargdefaults, proconfig, pg_get_userbyid(proowner) as funcowner, description,
(SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=pr.oid) AS labels,
(SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=pr.oid) AS providers
FROM pg_proc pr
JOIN pg_type typ ON typ.oid=prorettype
JOIN pg_namespace typns ON typns.oid=typ.typnamespace
JOIN pg_language lng ON lng.oid=prolang
LEFT OUTER JOIN pg_description des ON (des.objoid=pr.oid AND des.classoid='pg_proc'::regclass)
WHERE proisagg = FALSE AND pronamespace = 16579::oid
AND (typname IN ('trigger', 'event_trigger')
AND lanname NOT IN ('edbspl', 'sql', 'internal')) ORDER BY proname
QUERY : 12:12:12: Set query (localhost:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type
QUERY : 12:12:12: Set query (localhost:5432): SELECT c.oid, c.xmin, c.relname,c.reltablespace AS spcoid, c.relkind, c.relispopulated AS ispopulated,spc.spcname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS definition,
(SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=c.oid AND sl1.objsubid=0) AS labels,
(SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=c.oid AND sl2.objsubid=0) AS providers,
substring(array_to_string(c.reloptions, ',') FROM 'security_barrier=([a-z|0-9]*)') AS security_barrier, substring(array_to_string(c.reloptions, ',') FROM 'fillfactor=([0-9]*)') AS fillfactor
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS autovacuum_enabled
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS autovacuum_vacuum_threshold
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_vacuum_scale_factor
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS autovacuum_analyze_threshold
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_analyze_scale_factor
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS autovacuum_vacuum_cost_delay
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS autovacuum_vacuum_cost_limit
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS autovacuum_freeze_min_age
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS autovacuum_freeze_max_age
, substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS autovacuum_freeze_table_age
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS toast_autovacuum_enabled
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS toast_autovacuum_vacuum_threshold
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_vacuum_scale_factor
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS toast_autovacuum_analyze_threshold
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_analyze_scale_factor
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS toast_autovacuum_vacuum_cost_delay
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS toast_autovacuum_vacuum_cost_limit
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS toast_autovacuum_freeze_min_age
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS toast_autovacuum_freeze_max_age
, substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS toast_autovacuum_freeze_table_age
, c.reloptions AS reloptions, tst.reloptions AS toast_reloptions
, (CASE WHEN c.reltoastrelid = 0 THEN false ELSE true END) AS hastoasttable
,
substring(array_to_string(c.reloptions, ',') FROM 'check_option=([a-z]*)') AS check_option
FROM pg_class c
LEFT OUTER JOIN pg_tablespace spc on spc.oid=c.reltablespace
LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and des.objsubid=0 AND des.classoid='pg_class'::regclass)
LEFT OUTER JOIN pg_class tst ON tst.oid = c.reltoastrelid
WHERE ((c.relhasrules AND (EXISTS (
SELECT r.rulename FROM pg_rewrite r
WHERE ((r.ev_class = c.oid)
AND (bpchar(r.ev_type) = '1'::bpchar)) ))) OR (c.relkind = 'v'::char))
AND c.relnamespace = 16579::oid
ORDER BY relname
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='r'
QUERY : 12:12:12: Query result: {Opensim_Tester=a*r*w*d*D*x*t*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='S'
QUERY : 12:12:12: Query result: {Opensim_Tester=r*w*U*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='f'
QUERY : 12:12:12: Query result: {Opensim_Tester=X*/postgres}
QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='T'
QUERY : 12:12:12: Query result: {Opensim_Tester=U*/postgres}
STATUS : 12:12:12: Restoring previous environment... (392 msec)
INFO : 12:12:14: Displaying properties for Database opensim
STATUS : 12:12:14: Retrieving details on database opensim...
STATUS : 12:12:15: Retrieving details on database opensim... (11 msec)
INFO : 12:12:19: Displaying properties for Server localhost:5432
STATUS : 12:12:19: Retrieving details on server localhost...
QUERY : 12:12:19: Scalar query (localhost:5432): SELECT version();
QUERY : 12:12:19: Query result: PostgreSQL 10.1 (Debian 10.1-3) on x86_64-pc-linux-gnu, compiled by gcc (Debian 7.2.0-19) 7.2.0, 64-bit
STATUS : 12:12:19: Retrieving details on server localhost... (31 msec)
INFO : 12:14:03: Storing listed servers for later...
INFO : 12:14:03: Stored 1 servers.
More information about the Pkg-postgresql-public
mailing list