From: Tom Lane <tgl@sss.pgh.pa.us>
To: ken.zito@tmctechnologies.com
Cc: pgsql-docs@postgresql.org
Subject: Re: Admin catalog setup
Date: Wed, 10 Aug 2016 17:30:03 -0400
Message-ID: <29015.1470864603@sss.pgh.pa.us> (raw)
In-Reply-To: <20160810154817.1427.75320@wrigleys.postgresql.org>
References: <20160810154817.1427.75320@wrigleys.postgresql.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
ken.zito@tmctechnologies.com writes:
> Page: https://www.postgresql.org/docs/9.2/static/adminpack.html
> Description:
> This is the script shown on the website:
> int8 pg_catalog.pg_file_write(fname text, data text, append bool)
> bool pg_catalog.pg_file_rename(oldname text, newname text, archivename text)
> bool pg_catalog.pg_file_rename(oldname text, newname text)
> bool pg_catalog.pg_file_unlink(fname text)
> setof record pg_catalog.pg_logdir_ls()
> /* Renaming of existing backend functions for pgAdmin compatibility */
> int8 pg_catalog.pg_file_read(fname text, data text, append bool)
> bigint pg_catalog.pg_file_length(text)
> int4 pg_catalog.pg_logfile_rotate()
My goodness, that's an embarrassingly bad excuse for actual documentation,
isn't it. I'm surprised this has been there so long and no one's tried to
improve it. Maybe I will.
> It states that it should be run as a superuser. I am new to postgresql. I
> ran these step because I will be using pgadmin3. I ran the scripts in psql
> as myself who is a superuser. I got nothing back from these commands. How
> can I check if it ran correctly?
It didn't, because those are just function prototypes not SQL commands.
(If you'd added a semicolon at the end, you'd have gotten a syntax error,
but if you didn't then psql is probably still waiting for you to complete
the command.) What you are supposed to do to install adminpack, these
days, is say "CREATE EXTENSION adminpack;".
FWIW, though I'm not at all familiar with pgAdmin, I'd have guessed that
it could/would do this for you.
regards, tom lane
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, ken.zito@tmctechnologies.com
Subject: Re: Admin catalog setup
In-Reply-To: <29015.1470864603@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox