Feature #3131
PostgreSQL database server
Status: | CLOSED | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due 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.
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
- 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