Huh.. Been searching and googled almost the whole internet for regarding my issue 🙂
My problem is that I dont quite get it how to setup multiuser postgresql. I have allready installed postgresql and setup apache so it works with php(our system is FreeBSD based).
I also installed phpPgAdmin so that our clients could use it just like they use phpmyadmin for mysql.
Ok. I created a testuser and testdatabase to test how it works. Problem is that the testuser sees the other databases too(I created some with my superuser account). Althought the user cant do anything on them but I would like it to be just like mysql with phpmyadmin: user sees only their own database.
I've been reading manuals and other things but I just cant get in my head how the hell can I create a multiuser databasesystem for our server with numerous virtualhosts?
Or am I looking this problem wrong? Should I create a whole database cluster for each user or what?
Also I would like to know whats the best way to authenticate. Database should only be accessible from localhost using socket connection. I have tried few other options but couldnt get them to work so I have the default line(which works) in pg_hba.conf:
# "local" is for Unix domain socket connections only
local all all trust
