3
rated 0 times
[
3]
[
0]
/ answers: 1 / hits: 14639
/ 2 Years ago, wed, september 7, 2022, 9:49:16
I installed postgres under Lubuntu 13.04. When I try to run it:
sudo -u postgres psql
it gives me this error:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
I can start it changing the port:
sudo -u postgres -i
export PGPORT=5433
psql
but I would to make it the default port. I tried to add export PGPORT=5433
to the .bashrc of postgres user, but it doesn't work; it seems that .bashrc is not executed with sudo -u
, since if I do:
sudo -u postgres -i
. .bashrc
psql
it works.
Is there a way to make sudo -u USER -i
execute .bashrc, or is there another way to make the change of that environment variable permanent for postgres user?
More From » lubuntu