Re: Make & Install contrib/tablefunc Problems - Mailing list pgsql-general

On Mon, Jan 25, 2010 at 04:05:57PM +0100, Stefan Schwarzer wrote:
> Guess I'd need to do this as/with postgres user/role.

Yup, or at least somebody with superuser rights.  Try "\du" in psql.

> But really not
> sure how this goes. Thought it should be something like this:
>
>     sudo su - postgres -c '/usr/local/pgsql/bin/pgsql' < tablefunc.sql
>
> But that's no correct.

Looks about right, what do you get back?

The following does basically the same thing, but I find it a bit easier
to follow:

  sudo -u postgres /usr/local/pgsql/bin/pgsql < tablefunc.sql

--
  Sam  http://samason.me.uk/