Skip to content
Branch: master
Find file History
Pull request Compare This branch is 2 commits ahead, 1008 commits behind develop.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
src
.gitignore
LICENSE
README.md
pom.xml

README.md

li.strolch.persistence.postgresql

Build Status

PostgreSQL Persistence Implementation for Strolch

Setup

  1. Install PostgreSQL version with at least version 9.1: $ sudo aptitude install postgresql postgresql-client

  2. Set a password for user 'postgres' $ sudo -u postgres psql postgres $ postgres=# \password postgres

  3. Create the user and DB: $ sudo -u postgres psql $ postgres=# create user testUser with password 'test'; create database testdb; GRANT ALL PRIVILEGES ON DATABASE testdb to testuser; GRANT CONNECT ON DATABASE testdb TO testuser ;

For tests:

create user testUser with password 'test'; create database testdb; GRANT ALL PRIVILEGES ON DATABASE testdb to testuser; GRANT CONNECT ON DATABASE testdb TO testuser ;

create user testuser1 with password 'test'; create database testdb1; GRANT ALL PRIVILEGES ON DATABASE testdb1 to testuser1; GRANT CONNECT ON DATABASE testdb1 TO testuser1 ;

create user testuser2 with password 'test'; create database testdb2; GRANT ALL PRIVILEGES ON DATABASE testdb2 to testuser2; GRANT CONNECT ON DATABASE testdb2 TO testuser2 ;

  1. Added new component, setting properties for PostgreSQL DB:

    PersistenceHandler li.strolch.persistence.api.StrolchPersistenceHandler li.strolch.persistence.postgresql.PostgreSqlPersistenceHandler false jdbc:postgresql://localhost/testdb testUser test `
  2. Create tables, or allow strolch to due it for you.

Appendix

  1. To drop the user and DB: $ sudo -u postgres psql postgres $ postgres=# revoke ALL PRIVILEGES ON DATABASE testdb from testuser; drop user testuser; drop database testdb;

  2. Create a database: $ createdb -p 5432 -O drupal -U drupal -E UTF8 testingsiteone -T template0

  3. Dropping the database $ dropdb -p 5432 -U drupal testingsiteone

  4. Dumping the database $ pg_dump -p 5432 -h localhost -Fc -U drupal --no-owner testingsiteone > /tmp/testingsiteone_$(date +"%Y-%m-%d_%s").pgdump

  5. Restoring the database $ pg_restore -p 5432 -h localhost -Fc -d testingsiteone -U drupal --no-owner < /tmp/path-to-the-file.pgdump

References

http://www.pixelite.co.nz/article/installing-and-configuring-postgresql-91-ubuntu-1204-local-drupal-development

You can’t perform that action at this time.