Search Postgresql Archives

Re: issues when installing postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 10 May 2018 at 09:45, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx <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@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com>




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux