On Thu, Feb 05, 2009 at 08:12:48AM +0000, Sebastian Tennant wrote: > This is why you need to type 'sudo su postgres -c psql template1'. A little shortcut, you can do the above from sudo as: sudo -u postgres psql template1 This was pointed out to me by another kind soul on this list, but I can't, for the life of me, remember who though! Sorry -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general