Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Installing PostgresQL /pgadmin3 on ubuntu

pickarooney · 2015-01-30 17:51:47

I've been trying to do this for several hours and each time I try I end up further and further from what I'm trying to do. First up I got it installed from the command line in seconds and configured a password. However, pgadmin would not let me set up a server as it rejected my password every time. I tried changing it…

30-01-2015 06:51PM

#1

pickarooney

Moderators, Arts Moderators Posts: 36,233 Mod ✭✭✭✭

Join Date: June 2002

Posts: 35189

I've been trying to do this for several hours and each time I try I end up further and further from what I'm trying to do.

First up I got it installed from the command line in seconds and configured a password. However, pgadmin would not let me set up a server as it rejected my password every time. I tried changing it three times but it just wasn't having any of it. I wiped everything and started again. Same thing. On the third attempt things started to get worse and no amount of googling the various errors brought any resolution.

On a new clean install now and I'm stuck at this stage:
postgresql postgresql-contrib installed

createdb gives me Error: You must install at least one postgresql-client-<version> package.
postgresql-client-9.3 is installed

Any quick and easy steps to completely clean this up and start afresh with a working postgres server and create a database? This should be trivial but at every step I get insoluble errors.

0