I'm using pgAdmin III 1.18.1 on Ubuntu 12.04. Whenever I reboot my machine, pgAdmin does not remember my server connections. If I enter the server connections and then close pgadmin3 and reopen, the server connections are retained, it is only when I reboot my machine that the connections are lost.
After I create my server connections and close pgAdmin I see that the .pgadmin3
file is created just fine:
benc@Ubuntu-T7400:~$ ls -al | grep .pgadmin3
-rw-rw-r-- 1 benc benc 2088 Mar 28 11:57 .pgadmin3
Restarting pgadmin3 will then display my server connections. But if I reboot my machine, my .pgadmin3
file is set to 0 bytes.
After a reboot of Ubtuntu:
benc@Ubuntu-T7400:~$ ls -al | grep .pgadmin3
-rw-rw-r-- 1 benc benc 0 Mar 28 12:10 .pgadmin3
Any idea what might be going on here?
If pgAdmin displays this message, there are two possible reasons for this: the database server isn't running - simply start it. the server isn't configured to accept TCP/IP requests on the address shown.
If pgAdmin is installed in Server mode (the default mode), you can use the platform-specific File manager dialog to upload files that support SSL encryption to the server.
“Could not connect to server: Connection refused” To be sure that PostgreSQL is running, you can also restart it with systemctl restart postgresql. If this does not fix the problem, the most likely cause of this error is that PostgreSQL is not configured to allow TCP/IP connections.
I also gone through the same issue. But I have fixed this issue by following.
Actually .pgadmin3 file is missing from my home folder. So, I created it manually.
vish@Ubuntu:~$ ls -al | grep .pgadmin3
-rw-rw-r-- 1 vish vish 0 Jul 31 13:01 .pgadmin3
By default user will not have access to execute that file. So I gave full access rights on this file.
vish@Ubuntu:~$ sudo chmod a+wx .pgadmin3
So now it will look like:
-rwxrwxrwx 1 vish vish 0 Jul 31 13:01 .pgadmin3
Now every thing is working good.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With