Hi,
In PG Admin 4, I use the dashboard, server activity to explore sessions on
PG v12.1.
In the Details panel of the session, I can see the start of the SQL, but
when it's a long text query on multiple lines, How can I access the entire
SQL command ?
In PGAdmin 3 (on oldest PG v9.4), in tool serv
the restart doesn't work. I worked around and using pg_ctl to reload. Service
stopped and can't start up the service (pg_ctl: could not start server). Even
start with postgresql-11 with and/out .service.systemctl restart postgresql-11
systemctl restart postgresql-11.service
Bach-Nga
No one i
You rapidly confuse the systemd process if you manually start/stop/restart
PostgreSQL by hand. Always use the service or systemctl command for doing
anything.
—
Jay
Sent from my iPad
> On Dec 5, 2019, at 10:31 AM, Pepe TD Vo wrote:
>
>
> yes I do have a righ systemd service file named 'pos
yes I do have a righ systemd service file named 'postgresql-11' and its located
/usr/lib/systemd/system/
Here what I did so far aftermake install.
mkdir /usr/local/pgsql/log
Run
./usr/local/pgsql/bin/pg_ctl –D/postgres_data/pgsql/data –l
/usr/local/pgsql/log/logfile start
psql
in the p
