Re: issues when installing postgres - Mailing list pgsql-general
| From | Tim Cross |
|---|---|
| Subject | Re: issues when installing postgres |
| Date | |
| Msg-id | CAC=50j9gF2bDEjyq2qJWQR_nOYc=5q=5m-8BjSRX4_rGy9bNzg@mail.gmail.com Whole thread Raw |
| In response to | Re: issues when installing postgres (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Responses |
Re: issues when installing postgres
(Antonio Silva <aolinto.lst@gmail.com>)
|
| List | pgsql-general |
On 10 May 2018 at 09:45, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 05/09/2018 02:47 PM, Antonio Silva wrote:Hello Adrian
Are you using the Ubuntu or Postgres repos?
> I'm using the Ubuntu repos
Can you connect to Postgres using psql?
> No I cannot
What does ps ax | grep post show?
My guess is you are going to have to reinstall Postgres.
Thanks
Antonio
2018-05-09 10:36 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>: adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.
On 05/08/2018 05:54 PM, Antonio Silva wrote:
Hello!
Comments inline.
I bought a new computer and I installed Ubuntu 18.04 and after
PostgreSQL.
sudo apt install postgresql postgresql-contrib pgadmin3
Are you using the Ubuntu or Postgres repos?
Nevertheless I had some issues with configuration files and
decided to
uninstall it completely
sudo apt purge postgresql postgresql-contrib pgadmin3
When I installed it again I notice that postgresql.conf and
pg_hba.conf
were the oldies files. Then I uninstall Postgres once more and
removed the
directory /etc/postgresql/
After a new install I noticed that the directory
/etc/postgresql/ was
completely empty - it was not created again. There are no more
postgresql.conf and pg_hba.conf files. I could find only
postgresql.conf.sample and pg_hba.conf.sample at
/usr/share/postgresql/10
/etc/init.d/postgresql status says that Postgres is running fine
Can you connect to Postgres using psql?
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled;
vendor
preset: enabled)
Active: active (exited) since Tue 2018-05-08 10:43:23 -03; 1h
55min ago
Process: 6451 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 6451 (code=exited, status=0/SUCCESS)
To be running the server would need its conf files somewhere.
What should I have to do to heve the folder /etc/postgresql/10/
... and all
its files agais?
If you are going to use the packages then yes.
I really appreciate any help. Thanks in advance.
All the best
-- Antônio Olinto Ávila da Silva
-- Adrian Klavercom>
--
Adrian Klaver
adrian.klaver@aklaver.com
Probably not relevant, but I noticed your also installing pgadmin3. I don't believe pgadmin3 will work with Postgres 10. You need pgadmin4, which isn't available as a package on ubuntu 18.04.
Also, be aware that Ubuntu has also been pushing 'snaps', so make sure that Postgres hasn't been installed as a snap package (I think the command is snap lis). I recall when I tried to install postgres in 17.10, which I did from the 'software centre' on ubuntu, it initially installed it as a snap. I had to remove the snap and then use apt to get the normal deb package install. the snap package system does not use the normal locations for config files.
This could also be a ubuntu 18.04 issue. This version was only released a couple of weeks ago and it is the first version which has Postgres 10 as the default. I would try the following
1. use systemctl to stop postgresql service
2. remove all postgres packages making sure all config files are also removed
3. Use synaptic to make sure all postgres package and associated config files have been removed.
4. Reboot
5. run apt update and then apt upgrade
6 re-install using apt (not the software centre).
regards,
Tim
--
Tim Crosspgsql-general by date: