Loading a database, why do I need superuser? - Mailing list pgsql-general

From Gilley, Charles H.
Subject Loading a database, why do I need superuser?
Date
Msg-id 18D7589E9C44D21199AC00805F31B04708A005@atlanta_nt2.atlanta.glenayre.com
Whole thread Raw
Responses Re: [GENERAL] Loading a database, why do I need superuser?  (Simon Drabble <simon@fiddletrudge.dyn.ml.org>)
List pgsql-general
I'm in the process of loading a database on a virtual server.
Because I do not have root privileges (technically it is a shared machine),
I am encountering all sorts of hiccups.  Trying the copy command to
load the database with comma delimited data, I encounter this complaint:

    ERROR:  You must have Postgres superuser privilege to do a COPY
    directly to or from a file.  Anyone can COPY to stdout or from stdin

There is NO mention of this in the man page or documentation that I have
perused.  Perhaps I have a privilege problem?

Charles Gilley


pgsql-general by date:

Previous
From: "James Oden"
Date:
Subject: Re: [GENERAL] Re: Large Objects
Next
From: "Gilley, Charles H."
Date:
Subject: RE: [GENERAL] Loading a database, why do I need superuser?