Sophie

Sophie

distrib > Fedora > 18 > i386 > by-pkgid > 42af7caf167551d9121bb8e5e5ec8c60 > files > 2

owncloud-postgresql-4.5.13-3.fc18.noarch.rpm

Configure PostgreSQL for ownCloud
=================================
Before you can use PostgreSQL as database backend, you need to follow a couple of steps:

1. make sure that your PostgreSQL service is configured and running properly
2. log in to PostgreSQL as system user to create the database and a dedicated user account for ownCloud:
su - -c "psql" postgres
 CREATE USER username WITH PASSWORD 'password';
 CREATE DATABASE owncloud TEMPLATE template0 ENCODING 'UNICODE';
 ALTER DATABASE owncloud OWNER TO username;
 GRANT ALL PRIVILEGES ON DATABASE owncloud TO username;

Choose identifier and password accordingly.

Now you can launch the ownCloud setup screen, select PostgreSQL in the advanced settings and fill in your credentials.