pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Admin catalog setup 2+ messages / 2 participants [nested] [flat]
* Admin catalog setup @ 2016-08-10 15:48 ken.zito@tmctechnologies.com 2016-08-10 21:30 ` Re: Admin catalog setup Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: ken.zito@tmctechnologies.com @ 2016-08-10 15:48 UTC (permalink / raw) To: pgsql-docs The following documentation comment has been logged on the website: 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() 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? Thank you, -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Admin catalog setup 2016-08-10 15:48 Admin catalog setup ken.zito@tmctechnologies.com @ 2016-08-10 21:30 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2016-08-10 21:30 UTC (permalink / raw) To: ken.zito@tmctechnologies.com; +Cc: pgsql-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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-08-10 21:30 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-08-10 15:48 Admin catalog setup ken.zito@tmctechnologies.com 2016-08-10 21:30 ` Tom Lane <tgl@sss.pgh.pa.us>
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