Skip to main content

3 posts tagged with "postgresql"

View All Tags

· One min read

If when you start up pgAdmin III the following message is displayed:

An error has occurred: Error connecting to the server: fe_sendauth: no password supplied

in spite of having set the password in other startups, the error most likely be because the file permissions of .pgpass file are incorrect. In the .pgpass file, located in the home directory of the user who started pgAdmin III, user data to connect to postgres database are saved. Due to security reasons, permissions of .pgpass must be 600, that is, read and write only for the owner user.

For the same reason, if we do a restore (pg_restore) of a database with pgAdmin III without the correct permissions for .pgpass, we find that the restoration process will get stuck doing nothing, having no choice but to kill the pgAdmin III.

· One min read

Para realizar la desinstalación de forma automática se debe ejecutar uninstall-postgresql.app que está bajo /Library/PostgreSQL/8.4

Para ejecutar la desintalación de forma manual se deben ejecutar los siguiente comandos desde un Terminal:

lostinsoftware$> sudo /sbin/SystemStarter stop postgresql-8.4
Password:
lostinsoftware$> 
lostinsoftware$> sudo rm -rf /Applications/PostgreSQL\\ 8.4/
lostinsoftware$> sudo rm -rf /etc/postgres-reg.ini 
lostinsoftware$> sudo rm -rf /Library/StartupItems/postgresql-8.4
lostinsoftware$> sudo rm -rf /Library/PostgreSQL/8.4/
lostinsoftware$> sudo dscl . delete /users/postgres
delete: Invalid Path
<dscl\_cmd> DS Error: -14009 (eDSUnknownNodeName)
lostinsoftware$> sudo dscl . -delete /Users/postgres
lostinsoftware$>

También se podría incluir

rm /usr/bin/psql

También nos debemos asegurar que no queda ningún daemon activo relacionado con PostgreSQL en /Library/LaunchDaemons, como, por ejemplo, com.edb.launchd.postgresql-8.4.plist