Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: starting postgresql

  1. #1

    Default starting postgresql

    This is what I did:
    Code:
    systemctl status postgresql
     postgresql.service - PostgreSQL database server
       Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disa>
       Active: failed (Result: exit-code) since Sat 2018-12-29 13:32:02 EST; 3h 59min ago
    
    Dec 29 13:32:02 linux-s6kv systemd[1]: Starting PostgreSQL database server...
    Dec 29 13:32:02 linux-s6kv postgresql-script[1646]: postgres: could not access the server co>
    Dec 29 13:32:02 linux-s6kv postgresql-script[1646]: pg_ctl: could not start server
    Dec 29 13:32:02 linux-s6kv postgresql-script[1646]: Examine the log output.
    Dec 29 13:32:02 linux-s6kv systemd[1]: postgresql.service: Control process exited, code=exit>
    Dec 29 13:32:02 linux-s6kv systemd[1]: postgresql.service: Failed with result 'exit-code'.
    Dec 29 13:32:02 linux-s6kv systemd[1]: Failed to start PostgreSQL database server.
    
    
    Code:
    systemctl enable postgresql
    Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/sys
    temd/system/postgresql.service.
    
    Code:
    systemctl start postgresql
    Job for postgresql.service failed because the control process exited with error code.
    See "systemctl status postgresql.service" and "journalctl -xe" for details.
    
    
    Any ideas?

  2. #2
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,978
    Blog Entries
    14

    Default Re: starting postgresql

    How did you install postgresql ? No issues here in startinig the service.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  3. #3

    Default Re: starting postgresql

    Quote Originally Posted by Knurpht View Post
    How did you install postgresql ? No issues here in startinig the service.

    Code:
     zypper in -f postgresql10 postgresql10-docs postgresql10-test  
    
    

  4. #4
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,978
    Blog Entries
    14

    Default Re: starting postgresql

    Try
    Code:
    zypper in postgresql
    then retry starting the service,
    Last edited by Knurpht; 29-Dec-2018 at 18:10.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  5. #5
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    17,076

    Default Re: starting postgresql

    On Sat, 29 Dec 2018 22:36:03 +0000, ultra99 wrote:

    > Code: --------------------
    > systemctl start postgresql
    > Job for postgresql.service failed because the control process exited
    > with error code.
    > See "systemctl status postgresql.service" and "journalctl -xe" for
    > details.
    >
    >
    > --------------------
    >
    >
    > Any ideas?


    What do you see when you execute the recommended command to get the
    details?

    Jim



    --
    Jim Henderson
    openSUSE Forums Administrator
    Forum Use Terms & Conditions at http://tinyurl.com/openSUSE-T-C

  6. #6

    Default Re: starting postgresql

    Quote Originally Posted by Knurpht View Post
    Try
    Code:
    zypper in postgresql
    then retry starting the service,

    Code:
    zypper in postgresql
    Loading repository data...
    Reading installed packages...
    'postgresql' is already installed.
    No update candidate for 'postgresql-10-4.2.noarch'. The highest available version is already 
    installed.
    Resolving package dependencies...
    
    Nothing to do.
    
    

  7. #7

    Default Re: starting postgresql

    Quote Originally Posted by hendersj View Post
    On Sat, 29 Dec 2018 22:36:03 +0000, ultra99 wrote:

    > Code: --------------------
    > systemctl start postgresql
    > Job for postgresql.service failed because the control process exited
    > with error code.
    > See "systemctl status postgresql.service" and "journalctl -xe" for
    > details.
    >
    >
    > --------------------
    >
    >
    > Any ideas?


    What do you see when you execute the recommended command to get the
    details?

    Jim



    --
    Jim Henderson
    openSUSE Forums Administrator
    Forum Use Terms & Conditions at http://tinyurl.com/openSUSE-T-C
    Code:
    journalctl -xe
    Dec 29 20:26:30 linux-s6kv plasmashell[2024]: qt.qpa.xcb: QXcbConnection: XCB error: 2 (BadV>
    Dec 29 20:26:31 linux-s6kv plasmashell[2024]: qt.qpa.xcb: QXcbConnection: XCB error: 2 (BadV>
    Dec 29 20:26:38 linux-s6kv systemd[1]: Starting PostgreSQL database server...
    -- Subject: Unit postgresql.service has begun start-up
    -- Defined-By: systemd
    -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --  
    -- Unit postgresql.service has begun starting up.
    Dec 29 20:26:38 linux-s6kv postgresql-script[12965]: postgres: could not access the server c>
    Dec 29 20:26:38 linux-s6kv postgresql-script[12965]: pg_ctl: could not start server
    Dec 29 20:26:38 linux-s6kv postgresql-script[12965]: Examine the log output.
    Dec 29 20:26:38 linux-s6kv systemd[1]: postgresql.service: Control process exited, code=exit>
    Dec 29 20:26:38 linux-s6kv systemd[1]: postgresql.service: Failed with result 'exit-code'.
    Dec 29 20:26:38 linux-s6kv systemd[1]: Failed to start PostgreSQL database server.
    -- Subject: Unit postgresql.service has failed
    -- Defined-By: systemd
    -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --  
    -- Unit postgresql.service has failed.
    --  
    -- The result is RESULT.
    
    
    Code:
    systemctl status postgresql.service  
     postgresql.service - PostgreSQL database server
       Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disab>
       Active: failed (Result: exit-code) since Sat 2018-12-29 20:29:58 EST; 21s ago
      Process: 13055 ExecStart=/usr/share/postgresql/postgresql-script start (code=exited, statu>
    
    Dec 29 20:29:58 linux-s6kv systemd[1]: Starting PostgreSQL database server...
    Dec 29 20:29:58 linux-s6kv postgresql-script[13055]: postgres: could not access the server c>
    Dec 29 20:29:58 linux-s6kv postgresql-script[13055]: pg_ctl: could not start server
    Dec 29 20:29:58 linux-s6kv postgresql-script[13055]: Examine the log output.
    Dec 29 20:29:58 linux-s6kv systemd[1]: postgresql.service: Control process exited, code=exit>
    Dec 29 20:29:58 linux-s6kv systemd[1]: postgresql.service: Failed with result 'exit-code'.
    Dec 29 20:29:58 linux-s6kv systemd[1]: Failed to start PostgreSQL database server.
    lines 1-12/12 (END)
    
    

  8. #8
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,978
    Blog Entries
    14

    Default Re: starting postgresql

    You don't show us whether you're invoking the commands as a user or as root.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  9. #9

    Default Re: starting postgresql

    Quote Originally Posted by Knurpht View Post
    You don't show us whether you're invoking the commands as a user or as root.
    all as root.

  10. #10
    Join Date
    Mar 2011
    Location
    Sauerland
    Posts
    4,016

    Default AW: starting postgresql

    Is your system up to date?
    Please update as root with su -l:
    Code:
    zypper dup
    Show:
    Code:
    zypper se -si postgre


    I have installed it here in a VBox:

    Code:
    tumbleweed:~ # zypper in -f postgresql10 postgresql10-docs postgresql10-test
    Loading repository data...
    Reading installed packages...
    Forcing installation of 'postgresql10-10.5-1.5.x86_64' from repository 'OSS'.
    Forcing installation of 'postgresql10-docs-10.5-1.5.noarch' from repository 'OSS'.
    Forcing installation of 'postgresql10-test-10.5-1.5.x86_64' from repository 'OSS'.
    Resolving package dependencies...
    
    The following 8 NEW packages are going to be installed:
      postgresql postgresql-docs postgresql-server postgresql-test postgresql10 postgresql10-docs postgresql10-server postgresql10-test
    
    The following 3 recommended packages were automatically selected:
      postgresql10 postgresql10-docs postgresql10-server
    
    8 new packages to install.
    Overall download size: 9.1 MiB. Already cached: 0 B. After the operation, additional 51.4 MiB will be used.
    Continue? [y/n/...? shows all options] (y): 
    Retrieving package postgresql-10-4.2.noarch                                                                                                                                  (1/8),  11.7 KiB (  713   B unpacked)
    Retrieving: postgresql-10-4.2.noarch.rpm ...................................................................................................................................................................[done]
    Retrieving package postgresql10-docs-10.5-1.5.noarch                                                                                                                         (2/8),   2.3 MiB ( 17.1 MiB unpacked)
    Retrieving: postgresql10-docs-10.5-1.5.noarch.rpm ............................................................................................................................................[done (680.1 KiB/s)]
    Retrieving package postgresql10-10.5-1.5.x86_64                                                                                                                              (3/8),   1.4 MiB (  6.2 MiB unpacked)
    Retrieving: postgresql10-10.5-1.5.x86_64.rpm .................................................................................................................................................[done (664.2 KiB/s)]
    Retrieving package postgresql-docs-10-4.2.noarch                                                                                                                             (4/8),  10.9 KiB (   83   B unpacked)
    Retrieving: postgresql-docs-10-4.2.noarch.rpm ................................................................................................................................................[done (222.3 KiB/s)]
    Retrieving package postgresql-server-10-4.2.noarch                                                                                                                           (5/8),  19.3 KiB (  4.5 KiB unpacked)
    Retrieving: postgresql-server-10-4.2.noarch.rpm ............................................................................................................................................................[done]
    Retrieving package postgresql10-server-10.5-1.5.x86_64                                                                                                                       (6/8),   4.2 MiB ( 18.9 MiB unpacked)
    Retrieving: postgresql10-server-10.5-1.5.x86_64.rpm ..........................................................................................................................................[done (677.2 KiB/s)]
    Retrieving package postgresql-test-10-4.2.noarch                                                                                                                             (7/8),  10.7 KiB (   83   B unpacked)
    Retrieving: postgresql-test-10-4.2.noarch.rpm ..............................................................................................................................................................[done]
    Retrieving package postgresql10-test-10.5-1.5.x86_64                                                                                                                         (8/8),   1.1 MiB (  9.3 MiB unpacked)
    Retrieving: postgresql10-test-10.5-1.5.x86_64.rpm ............................................................................................................................................[done (648.7 KiB/s)]
    Checking for file conflicts: ...............................................................................................................................................................................[done]
    (1/8) Installing: postgresql-10-4.2.noarch .................................................................................................................................................................[done]
    (2/8) Installing: postgresql10-docs-10.5-1.5.noarch ........................................................................................................................................................[done]
    (3/8) Installing: postgresql10-10.5-1.5.x86_64 .............................................................................................................................................................[done]
    (4/8) Installing: postgresql-docs-10-4.2.noarch ............................................................................................................................................................[done]
    (5/8) Installing: postgresql-server-10-4.2.noarch ..........................................................................................................................................................[done]
    Additional rpm output:
    Updating /etc/sysconfig/postgresql ...
    
    
    (6/8) Installing: postgresql10-server-10.5-1.5.x86_64 ......................................................................................................................................................[done]
    (7/8) Installing: postgresql-test-10-4.2.noarch ............................................................................................................................................................[done]
    (8/8) Installing: postgresql10-test-10.5-1.5.x86_64 ........................................................................................................................................................[done]
    Executing %posttrans scripts ...............................................................................................................................................................................[done]
    tumbleweed:~ # systemctl enable postgresql.service 
    Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service.
    tumbleweed:~ # systemctl start postgresql.service 
    tumbleweed:~ # systemctl status postgresql.service 
    ● postgresql.service - PostgreSQL database server
       Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
       Active: active (running) since Sun 2018-12-30 08:14:48 CET; 12s ago
      Process: 4897 ExecStart=/usr/share/postgresql/postgresql-script start (code=exited, status=0/SUCCESS)
     Main PID: 4922 (postgres)
        Tasks: 8 (limit: 4709)
       Memory: 118.6M
       CGroup: /system.slice/postgresql.service
               ├─4922 /usr/lib/postgresql10/bin/postgres -D /var/lib/pgsql/data
               ├─4923 postgres: logger process   
               ├─4925 postgres: checkpointer process   
               ├─4926 postgres: writer process   
               ├─4927 postgres: wal writer process   
               ├─4928 postgres: autovacuum launcher process   
               ├─4929 postgres: stats collector process   
               └─4930 postgres: bgworker: logical replication launcher   
    
    Dec 30 08:14:12 tumbleweed systemd[1]: Starting PostgreSQL database server...
    Dec 30 08:14:12 tumbleweed postgresql-script[4897]: Initializing PostgreSQL 10.5 at location /var/lib/pgsql/data
    Dec 30 08:14:47 tumbleweed postgresql-script[4897]: 2018-12-30 08:14:47.803 CET   [4922]LOG:  listening on IPv4 address "127.0.0.1", port 5432
    Dec 30 08:14:47 tumbleweed postgresql-script[4897]: 2018-12-30 08:14:47.803 CET   [4922]LOG:  could not bind IPv6 address "::1": Cannot assign requested address
    Dec 30 08:14:47 tumbleweed postgresql-script[4897]: 2018-12-30 08:14:47.803 CET   [4922]HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
    Dec 30 08:14:47 tumbleweed postgresql-script[4897]: 2018-12-30 08:14:47.878 CET   [4922]LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
    Dec 30 08:14:47 tumbleweed postgresql-script[4897]: 2018-12-30 08:14:47.935 CET   [4922]LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
    Dec 30 08:14:47 tumbleweed postgresql-script[4897]: 2018-12-30 08:14:47.990 CET   [4922]LOG:  redirecting log output to logging collector process
    Dec 30 08:14:47 tumbleweed postgresql-script[4897]: 2018-12-30 08:14:47.990 CET   [4922]HINT:  Future log output will appear in directory "log".
    Dec 30 08:14:48 tumbleweed systemd[1]: Started PostgreSQL database server.
    tumbleweed:~ #
    Last edited by Sauerland; 30-Dec-2018 at 00:20.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •