Hi pgadmin-support I get the following pgAdmin III error every time i restore a database, using pgAdmin III
Error: File '' couldn't be removed (error 2: No such file or directory) Find attached the pgadmin log PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit Linux 3.19.0-26-generic #28~14.04.1-Ubuntu SMP Wed Aug 12 14:09:17 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux *Best Regards**Franklin Byaruhanga*
INFO : 08:33:39 PM: ############################################################## INFO : 08:33:39 PM: # pgAdmin III Version 1.20.0 Startup INFO : 08:33:39 PM: ############################################################## INFO : 08:33:39 PM: Compiled with dynamically linked SSL support INFO : 08:33:39 PM: Running a DEBUG build. INFO : 08:33:39 PM: i18n path : /usr/share/pgadmin3/i18n INFO : 08:33:39 PM: UI path : INFO : 08:33:39 PM: Doc path : /usr/share/pgadmin3/docs INFO : 08:33:39 PM: Branding path : /usr/share/pgadmin3/branding INFO : 08:33:39 PM: Plugins path : /usr/share/pgadmin3/plugins.d INFO : 08:33:39 PM: Settings INI : /usr/share/pgadmin3/settings.ini INFO : 08:33:39 PM: PG pg_dump : /usr/bin/pg_dump INFO : 08:33:39 PM: PG pg_dumpall : /usr/bin/pg_dumpall INFO : 08:33:39 PM: PG pg_restore : /usr/bin/pg_restore INFO : 08:33:39 PM: EDB pg_dump : INFO : 08:33:39 PM: EDB pg_dumpall: INFO : 08:33:39 PM: EDB pg_restore: INFO : 08:33:39 PM: Greenplum pg_dump : INFO : 08:33:39 PM: Greenplum pg_dumpall: INFO : 08:33:39 PM: Greenplum pg_restore: INFO : 08:33:39 PM: Using embedded XRC data. INFO : 08:33:40 PM: PG Help : http://www.postgresql.org/docs/current/static/ INFO : 08:33:40 PM: EDB Help : http://www.enterprisedb.com/docs/en/current/server/ INFO : 08:33:40 PM: Greenplum Help: http://docs.gopivotal.com/gpdb/index.html/ INFO : 08:33:40 PM: Slony Help : http://www.slony.info/documentation/ INFO : 08:33:40 PM: Using fontmetrics 8/17, 10 Point INFO : 08:33:40 PM: Native Description 'Monospace 10' INFO : 08:33:40 PM: Draw size of 'M': w=8, h=17, descent 4, external lead 0. INFO : 08:33:40 PM: Draw size of 'g': w=8, h=17, descent 4, external lead 0. INFO : 08:33:40 PM: Draw size of 'Mg': w=16, h=17, descent 4, external lead 0. INFO : 08:33:40 PM: Loading plugin ini files from /usr/share/pgadmin3/plugins.d INFO : 08:33:40 PM: Loading plugin utilities from /usr/share/pgadmin3/plugins.d/plugins.ini INFO : 08:33:40 PM: Adding plugin utility: PSQL Console INFO : 08:33:40 PM: Command: /usr/bin/x-terminal-emulator -e "$$PGBINDIR/psql" --host "$$HOSTNAME" --port $$PORT --username "$$USERNAME" "$$DATABASE" INFO : 08:33:40 PM: Description: Open a PSQL console to the current database. INFO : 08:33:40 PM: Database?: Yes INFO : 08:33:40 PM: Set Password?: Yes INFO : 08:33:40 PM: Reloading servers... INFO : 08:33:40 PM: Loading previously registered servers INFO : 08:33:40 PM: Loading servers registered on the local machine INFO : 08:33:40 PM: Displaying properties for Servers Servers STATUS : 08:33:40 PM: Retrieving details on servers... STATUS : 08:33:40 PM: Retrieving details on servers... (0.00 secs) INFO : 08:33:47 PM: Displaying properties for Server localhost:5432 STATUS : 08:33:47 PM: Retrieving details on server localhost... STATUS : 08:33:47 PM: Retrieving details on server localhost... (0.00 secs) INFO : 08:33:47 PM: Attempting to create a connection object... INFO : 08:33:47 PM: Using password file /home/byaruhaf/.pgpass STATUS : 08:33:47 PM: Connecting to database... INFO : 08:33:47 PM: Opening connection with connection string: host='localhost' dbname='postgres' user='postgres' port=5432 application_name='pgAdmin III - Browser' QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT version(); QUERY : 08:33:47 PM: Query result: PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit QUERY : 08:33:47 PM: 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 : 08:33:47 PM: Setting client_encoding to 'UNICODE' QUERY : 08:33:47 PM: 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 QUERY : 08:33:47 PM: Set query (localhost:5432): SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user; STATUS : 08:33:47 PM: Connecting to database... (0.01 secs) STATUS : 08:33:47 PM: Restoring previous environment... INFO : 08:33:47 PM: pgServer object initialised as required. INFO : 08:33:47 PM: Adding child object to server localhost:5432 QUERY : 08:33:47 PM: 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 : 08:33:47 PM: 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 : 08:33:47 PM: 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 : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT has_table_privilege('pg_authid', 'SELECT') QUERY : 08:33:47 PM: Query result: t QUERY : 08:33:47 PM: 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 : 08:33:47 PM: Scalar query (localhost:5432): SELECT has_table_privilege('pg_authid', 'SELECT') QUERY : 08:33:47 PM: Query result: t QUERY : 08:33:47 PM: 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 : 08:33:47 PM: Set query (localhost:5432): SELECT setting FROM pg_settings WHERE name IN ('autovacuum', 'track_counts') INFO : 08:33:47 PM: Displaying properties for Databases Databases INFO : 08:33:47 PM: Displaying properties for Database dvd INFO : 08:33:47 PM: Opening connection with connection string: host='localhost' dbname='dvd' user='postgres' port=5432 application_name='pgAdmin III - Browser' QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT version(); QUERY : 08:33:47 PM: Query result: PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit QUERY : 08:33:47 PM: 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 = 20827 INFO : 08:33:47 PM: Setting client_encoding to 'UNICODE' QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT proname FROM pg_proc WHERE proname='pg_get_viewdef' AND proargtypes[1]=16 QUERY : 08:33:47 PM: Query result: pg_get_viewdef QUERY : 08:33:47 PM: Scalar query (localhost:5432): SHOW search_path QUERY : 08:33:47 PM: Query result: "$user",public QUERY : 08:33:47 PM: Set query (localhost:5432): SELECT nspname, session_user=nspname AS isuser FROM pg_namespace QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='r' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='S' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='f' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='T' INFO : 08:33:47 PM: Query returned no tuples INFO : 08:33:47 PM: Adding child object to database dvd QUERY : 08:33:47 PM: 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)) ) ORDER BY 1, nspname QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11625::oid AND defaclobjtype='r' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11625::oid AND defaclobjtype='S' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11625::oid AND defaclobjtype='f' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11625::oid AND defaclobjtype='T' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='r' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='S' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='f' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='T' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: 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 : 08:33:47 PM: 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 : 08:33:47 PM: 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)) ) ORDER BY 1, nspname QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 99::oid AND defaclobjtype='r' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 99::oid AND defaclobjtype='S' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 99::oid AND defaclobjtype='f' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 99::oid AND defaclobjtype='T' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11321::oid AND defaclobjtype='r' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11321::oid AND defaclobjtype='S' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11321::oid AND defaclobjtype='f' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11321::oid AND defaclobjtype='T' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11320::oid AND defaclobjtype='r' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11320::oid AND defaclobjtype='S' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11320::oid AND defaclobjtype='f' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11320::oid AND defaclobjtype='T' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 22488::oid AND defaclobjtype='r' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 22488::oid AND defaclobjtype='S' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 22488::oid AND defaclobjtype='f' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 22488::oid AND defaclobjtype='T' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: 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 : 08:33:47 PM: 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 : 08:33:47 PM: Query result: 0 QUERY : 08:33:47 PM: 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=20827) SELECT rolname, split_part(config, '=', 1) AS variable, replace(config, split_part(config, '=', 1) || '=', '') AS value FROM configs INFO : 08:33:47 PM: Displaying properties for Schemas Schemas INFO : 08:33:47 PM: Displaying properties for Schema public INFO : 08:33:47 PM: Adding child object to schema public QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY c.collname QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY d.typname QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY cfg.cfgname QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY dict.dictname QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY prs.prsname QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY tmpl.tmplname QUERY : 08:33:47 PM: 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 : 08:33:47 PM: Scalar query (localhost:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclass AND attname = 'proargdefaults' QUERY : 08:33:47 PM: Query result: 1 QUERY : 08:33:47 PM: Set query (localhost:5432): SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) 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 = 22488::oid AND typname NOT IN ('trigger', 'event_trigger') ORDER BY proname QUERY : 08:33:47 PM: Set query (localhost:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY relname QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY rel.relname QUERY : 08:33:47 PM: Set query (localhost:5432): SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) 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 = 22488::oid AND (typname IN ('trigger', 'event_trigger') AND lanname NOT IN ('edbspl', 'sql', 'internal')) ORDER BY proname QUERY : 08:33:47 PM: Set query (localhost:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type QUERY : 08:33:47 PM: 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 = 22488::oid ORDER BY relname QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 22488::oid AND defaclobjtype='r' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 22488::oid AND defaclobjtype='S' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 22488::oid AND defaclobjtype='f' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 22488::oid AND defaclobjtype='T' INFO : 08:33:47 PM: Query returned no tuples QUERY : 08:33:47 PM: 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 : 08:33:47 PM: Scalar query (localhost:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclass AND attname = 'proargdefaults' QUERY : 08:33:47 PM: Query result: 1 STATUS : 08:33:47 PM: Restoring previous environment... (0.12 secs) INFO : 08:33:50 PM: Displaying properties for Database dvd STATUS : 08:33:50 PM: Retrieving details on database dvd... STATUS : 08:33:50 PM: Retrieving details on database dvd... (0.00 secs) INFO : 08:33:56 PM: Using password file /home/byaruhaf/.pgpass QUERY : 08:33:56 PM: Set query (localhost:5432): SELECT DISTINCT rolname FROM pg_roles db ORDER BY rolname ERROR : 08:34:29 PM: Error: File '' couldn't be removed (error 2: No such file or directory) INFO : 08:34:38 PM: Storing listed servers for later... INFO : 08:34:38 PM: Stored 1 servers.
-- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
