Feature #3131

PostgreSQL database server

Added by Giacomo Sanchietti over 6 years ago. Updated about 6 years ago.

Status:CLOSEDStart date:
Priority:NormalDue date:
Assignee:-% Done:

100%

Category:nethserver-postgresql
Target version:v6.6
Resolution: NEEDINFO:No

Description

The package should
  • install PostgreSQL server
  • execute first setup
  • setup base configuration

Backup and loading of databases will be delegated to single applications.

Associated revisions

Revision 4da855e2
Added by Giacomo Sanchietti over 6 years ago

First import. Refs #3131

Revision 78bddcc4
Added by Giacomo Sanchietti over 6 years ago

DB: change access default to none. Refs #3131

History

#1 Updated by Giacomo Sanchietti over 6 years ago

  • Category set to nethserver-postgresql
  • Status changed from NEW to TRIAGED
  • Target version set to v6.6
  • % Done changed from 0 to 20

#2 Updated by Giacomo Sanchietti over 6 years ago

  • Status changed from TRIAGED to ON_DEV
  • Assignee set to Giacomo Sanchietti
  • % Done changed from 20 to 30

#3 Updated by Giacomo Sanchietti over 6 years ago

  • Status changed from ON_DEV to MODIFIED
  • % Done changed from 30 to 60

#4 Updated by Giacomo Sanchietti over 6 years ago

  • Status changed from MODIFIED to ON_QA
  • Assignee deleted (Giacomo Sanchietti)
  • % Done changed from 60 to 70
Package in nethserver-testing:
  • nethserver-postgresql-1.0.0-1.1.g78bddcc.ns6.noarch.rpm
Test case
  • Install the package
  • Try to access the server with postgres user, the user must access the db without password:
    su - postgres -c "psql" 
    
  • Create a database and a new user, then try to access it with root shell. The client must request a password:
    psql -U <user> <db>
    

The server will be accessible only from localhost.

To create a database from postgres user:

CREATE database mytest;
REATE USER myuser WITH PASSWORD 'mypass';
GRANT ALL PRIVILEGES ON DATABASE mytest to myuser;

#5 Updated by Giacomo Sanchietti about 6 years ago

  • Assignee set to Vasco Castelo Branco

#6 Updated by Giacomo Sanchietti about 6 years ago

  • Status changed from ON_QA to VERIFIED
  • Assignee deleted (Vasco Castelo Branco)
  • % Done changed from 70 to 90

The issue has been VERIFIED.

Thanks to Vasco Branco.

#7 Updated by Giacomo Sanchietti about 6 years ago

  • Status changed from VERIFIED to CLOSED
  • % Done changed from 90 to 100
Released in nethserver-updates:
  • nethserver-postgresql-1.0.1-1.ns6.noarch.rpm

Developer manual:
http://docs.nethserver.org/projects/nethserver-devel/en/latest/postgresql.html

Also available in: Atom PDF