issues when installing postgres

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 Klaver
adrian.klaver@aklaver.com

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

Thanks

Antonio

2018-05-09 10:36 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:

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>>:

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 Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

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>>:

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 Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
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 Cross

Dear Tim and Adrian

Thanks for your attention.

Finally I solved the problem. In addition to deleting files as suggested it
seems to be important to *remove postgres user and group* (userdel -r
postgres, groupdel postgres) before the new install.

https://stackoverflow.com/questions/2748607/how-to-thoroughly-purge-and-reinstall-postgresql-on-ubuntu

And life goes on ...

All the best

Antonio Olinto

2018-05-09 21:15 GMT-03:00 Tim Cross <theophilusx@gmail.com>: