On 03/10/2016 05:07 PM, Robert McAlpine wrote:
Thank you for the quick reply.
I very recently had some success by doing a complete purge of
postgresql-9.5, reinstalling and then copying in the original data
directory (or I guess I could have just pointed to it, but w/e). I did
not expect this to
For future reference you can start the postmaster in single user mode
and create a new postgres account or grant the current one superuser
access if this happens again. Just google "Postgresql single user
mode".
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
Thank you for the quick reply.
I very recently had some success by doing a complete purge of
postgresql-9.5, reinstalling and then copying in the original data
directory (or I guess I could have just pointed to it, but w/e). I did not
expect this to work, as I thought it would just point to the ta
On 03/10/2016 04:11 PM, Robert McAlpine wrote:
Postgresql 9.5, Ubuntu 14.04.
I broke my ability to access postgres after attemping to install
postgres-xc (ironic, since I installed that to use pg_ctl to reload my
pg_hba.conf without restarting the entirety of postgres).
That is available with
Postgresql 9.5, Ubuntu 14.04.
I broke my ability to access postgres after attemping to install
postgres-xc (ironic, since I installed that to use pg_ctl to reload my
pg_hba.conf without restarting the entirety of postgres).
After doing so I can no longer access my databases via psql or any other