Repository with openmediavault-postgresql

    I reinstall whole server from the scratch. But it see that I can't use your both command at once, because DB will not start up:



    Maybe I will try edit config file by nano from Putty. Because on error message it seams like one order on line 24, but in webUI I add there like two lines.
    https://www.dropbox.com/s/2kht…95/OMV-PostgreSQL-004.png

    But, I can't run PostgreSQL with right config file from shell, too. ;(


    Zitat

    root@OMV-SERVER:~# /etc/init.d/postgresql start
    Starting PostgreSQL 9.1 database server: mainError: could not exec /usr/lib/postgresql/9.1/bin/pg_ctl /usr/lib/postgresql/9.1/bin/pg_ctl start -D /media/9a0daa7d-1ced-42e0-9da4-1bb0e9c175eb/PostgreSQL/ -l /var/log/postgresql/postgresql-9.1-main.log -s -o -c config_file="/etc/postgresql/9.1/main/postgresql.conf" : ... failed!
    failed!

    How much will OMV change system setting if I will install original Debian Wheezy with PostgreSQL and phpPgAdmin? In this case I will not install your OMV PostgreSQL plug-in. Two things is good on your plug-in:
    1.) Possibility to reset root password for database access.
    2.) Turn on/Turn off control manager.


    But universally, how much will be change Debian Wheze configuration from default configuration after installation OMV like application, please?


    I thank you very much for your answer before.

    • Offizieller Beitrag

    You are still using the data_directory option. This is probably your problem. Just specifying that data directory does not put database files there. Get the plugin working first before moving the database. I've installed the plugin many times in the last few days and it works fine every time.


    OMV is original Debian Wheezy. If you really want to install postgresql and phpPgAdmin, you can. OMV doesn't do anything to stop it.

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


    omv-extras.org plugins source code and issue tracker - github - changelogs


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    O.K. Maybe I found problem. PostgreSQL is not possible run without "data_directory", too.


    Zitat

    root@OMV-SERVER:~# /etc/init.d/postgresql start
    Starting PostgreSQL 9.1 database server: mainUse of uninitialized value $info{"pgdata"} in -d at /usr/bin/pg_ctlcluster line 335. Use of uninitialized value $info{"pgdata"} in concatenation (.) or string at /usr/bin/pg_ctlcluster line 336. Error: is not accessible or does not exist ... failed!failed!


    :|

    And second interesting thing is everytime when I try uninstal plugin it failed on this step: "postgresql-client-9.1" I will try your procedure to uninstall postgresql, what you wrote before.

    • Offizieller Beitrag

    On a fresh installation, install the plugin without the data_directory extra option (may still need share_buffers option on low memory systems) and it will work every time.

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


    omv-extras.org plugins source code and issue tracker - github - changelogs


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    Now, I am trying your method of reinstallation Postgresql:


    Zitat

    root@OMV-SERVER:~# dpkg -l | grep postgresql
    pi postgresql-9.1 9.1.15-0+deb7u1 amd64 object-relational SQL database, version 9.1 server
    pF postgresql-client-9.1 9.1.15-0+deb7u1 amd64 front-end programs for PostgreSQL 9.1
    pi postgresql-common 134wheezy4 all PostgreSQL database-cluster manager





    restart OS


    Zitat

    root@OMV-SERVER:~# userdel postgres


    restart OS

    • Offizieller Beitrag

    All of the package removes failed. It doesn't do any good to restart when they fail.


    Try apt-get purge postgresql*

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


    omv-extras.org plugins source code and issue tracker - github - changelogs


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    After restart I tried it again with success:


    Zitat

    root@OMV-SERVER:~# dpkg -r postgresql-9.1
    (Reading database ... 31474 files and directories currently installed.)
    Removing postgresql-9.1 ...


    Zitat

    root@OMV-SERVER:~# dpkg -r postgresql-client-9.1
    (Reading database ... 31276 files and directories currently installed.)
    Removing postgresql-client-9.1 ...


    Zitat

    root@OMV-SERVER:~# dpkg -r postgresql-common
    (Reading database ... 31031 files and directories currently installed.)
    Removing postgresql-common ...
    Removing 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
    Processing triggers for man-db ...


    reboot


    Zitat


    root@OMV-SERVER:~# rm -rfv /var/lib/postgresql /etc/postgresql
    root@OMV-SERVER:~# userdel postgres
    userdel: user 'postgres' does not exist



    Now, I will try install it again via WebUI (your plugin).

    Maybe I will do clean install again (of your distribution), because I can't save setiitings for Postgres, because WebUI give me error message "An error has occured" without details. Only for sure, because I have suspicion for JDownloader which it will be once installed it is not possible uninstall it (WebUI write some error during uninstallation process). And it is in everytime (of course with clean installation system try). Well I could have demage system from JDownloader.

    • Offizieller Beitrag

    8 gb is definitely not low system memory. I would try without the share_buffer option. I don't have to use it on any of my hardware systems. Just a low memory VM.

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


    omv-extras.org plugins source code and issue tracker - github - changelogs


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    O.K. It don't work. ;(


    Zitat

    Failed to execute command 'export LANG=C; invoke-rc.d 'postgresql' start 2>&1': Starting PostgreSQL 9.1 database server: mainThe PostgreSQL server failed to start. Please check the log output: 2015-04-10 18:41:31 CEST FATAL: could not create shared memory segment: Invalid argument 2015-04-10 18:41:31 CEST DETAIL: Failed system call was shmget(key=5432001, size=41205760, 03600). 2015-04-10 18:41:31 CEST HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the request size (currently 41205760 bytes), reduce PostgreSQL's shared memory usage, perhaps by reducing shared_buffers or max_connections. If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for. The PostgreSQL documentation contains more information about shared memory configuration. ... failed! failed! invoke-rc.d: initscript postgresql, action "start" failed.


    • Offizieller Beitrag

    Can you try installing the backports 3.16 kernel? That might be the difference. There is a button in omv-extras to install it.

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


    omv-extras.org plugins source code and issue tracker - github - changelogs


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!

Benutzerkonto erstellen Anmelden