Hacker News new | ask | show | jobs
by jakobegger 3839 days ago
I'd love to hear what issues you're facing (if you can remember any specifics). Its been a long time since I first installed PostgreSQL, but I also recall some difficulties. Some things have improved since (eg. it's no longer necessary to change shared memory kernel parameters) but some things are still pretty difficult (eg. correctly configuring pg_hba.conf).

Other things are just confusing to newcomers (eg. different meanings of the term "database" between MySQL and Postgres, or understanding schemas and search_path).

1 comments

Hey, I installed it via the available things on ubuntu software center, I have the graphical utility installed but when I try to connect to it, it says invalid password and I have no idea what the default password is since it didnt ask me
Have you created a user? If you don't create a user, and aren't acting as the postgres user, how do you expect to connect?
Sadly though I have no idea how to do that, can you direct me to some easy to understand installation guide?