pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
createlang problem with 8, what is correct?
2+ messages / 2 participants
[nested] [flat]

* createlang problem with 8, what is correct?
@ 2005-03-28 17:54  Tad Marko <tmarko@metrosplash.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Tad Marko @ 2005-03-28 17:54 UTC (permalink / raw)
  To: pgsql-admin

Howdy!

  createlang -U dbuser plpgsql dbname

Results in:

  createlang: language installation failed: ERROR:  permission denied  
  for language c

However, I can make it work with

  createlang -U postgres plpgsql dbname

Is the latter preferred, or do I have something misconfigured?

Thanks,
Tad

-- 
Tad Marko <tmarko@metrosplash.com>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: createlang problem with 8, what is correct?
@ 2005-03-28 19:26  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Tad Marko <tmarko@metrosplash.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-03-28 19:26 UTC (permalink / raw)
  To: Tad Marko <tmarko@metrosplash.com>; +Cc: pgsql-admin

Tad Marko <tmarko@metrosplash.com> writes:
> However, I can make it work with
>   createlang -U postgres plpgsql dbname
> Is the latter preferred, or do I have something misconfigured?

Createlang has to be done as a superuser.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-03-28 19:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-28 17:54 createlang problem with 8, what is correct? Tad Marko <tmarko@metrosplash.com>
2005-03-28 19:26 ` 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