FW: [GENERAL] Loading a database, ...

Well, I never did get the copy to work, so now I'm using an ODBC connection
to update my virtual server. Egad, this is slow, and I'm doing it from a
partial
T1 link (I think it's the odbc connection). Each record is going out and
doing
an insert into then a select. It's plodding along - anyway to make it
faster?

chg

> -----Original Message-----
> From: Gilley, Charles H. [SMTP:Charles(dot)Gilley(at)glenayre(dot)com]
> Sent: Friday, November 20, 1998 10:18 AM
> To: pgsql-general
> Subject: RE: [GENERAL] Loading a database, why do I need superuser?
>
> Halt, stop, cease this discussion! :) Seriously, I meant to say Postgres
> superuser, I really do understand the differences between root and the
> normal
> pgsql account. Unfortunately, I don't own the Postgres account either.
> Sorry for the ambiguity.
>
> Back to the copy issue: Okay, I understand the security issue with
> regards
> to the backend. Let me guess - that's why one has the option of the
> stdin/out
> feature.
>
> About this front end copy command... from psql I try:
>
> \copy tblauthors from tblAuthors.txt;
>
> which reports a broken pipe. I note that the syntax for the front
> end copy command does not mention quoting the filename or having
> the option of saying 'using delimiters...'.
>
> From the command line, I try the same command:
>
> cat tblAuthors.txt | psql -d gilley -c copy tblAuthors.txt from
> stdin using delimiters ','
>
> or
>
> cat tblAuthors.txt | psql -d gilley -c copy tblAuthors.txt from
> stdin
>
> which yield
>
> ERROR: parser: syntax error at or near ""
> Broken Pipe
>
>
> What is the correct magic spell?
>
> Charles Gilley - by the way, thanks for the quick responses.
>
> > -----Original Message-----
> > From: James Olin Oden [SMTP:joden(at)lee(dot)k12(dot)nc(dot)us]
> > Sent: Friday, November 20, 1998 9:48 AM
> > To: Gilley, Charles H.
> > Subject: Re: [GENERAL] Loading a database, why do I need superuser?
> >
> >
> > "Gilley, Charles H." wrote:
> >
> > > 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
> >
> > Hi Charles,
> >
> > Really you should never manage the postgress database as root at all.
> If
> > you
> > read the README and other installation notes that come with the
> > distribution you
> > will see that it _strongly_ suggests you create a postgres
> administrative
> > account (you can call it whatever you want, most of the world calls it
> > postgres), create the directory where you are going to install the
> > postgress
> > binaries, and then set it to be owned by this postgres administrative
> > user.
> >
> > I am not sure of all the repercussions, but the docs to express that
> there
> > are
> > some serious security risks to both your data and your system if you run
> > the
> > postgress application as root. Anyway, it really is all over the
> > docs...especially the installation docs.
> >
> > Hope this is helpful...james
> >