Please enable JavaScript to view this site.

Creating PostgreSQL database copies

To a large extent, copying a database is the same thing as creating a new one...

Enter the alias of the new database.

dsgn_database-alias

A customer profile with the same name as the database alias is created automatically. Database aliases and customer profiles are managed with the Alias, Customer and Guest Manager.

dsgn_alias-customer-guest-manager

Select PostgreSQL as your database server.        

dsgn_postgreSQL-database-server

Enter the name and password of the database administrator (DBA).

don’t confuse the DBA role with the administrator (”owner”) of the Efficy database

dsgn_database-administrator

Case-sensitivity of PostgreSQL

PostgreSQL table names and field names are case-sensitive. In addition, the default is supposed to be lowercase, even though you can create table and fields with uppercase characters!

Examples

create a table test. The query select * from test works; so does the query select * from “test”

create a table MyTest. The query select * from MyTest doesn’t work; the query select * from “MyTest” does

Efficy queries for PostgreSQL don’t use quoted table, field (or other database element) names; the default lowercase cast functions properly.

The database tables and fields are created with lowercase names in the database. The PostgreSQL engine converts all SQL commands to lowercase versions.

Fill out the server-specific information:

oenter the host here the database is located.

oenter the port. The default port is 5432.

The listening port can be easily changed in the settings file postgresql.conf, the main configuration file for the database server.

oenter the name of the database.

oenter the default table space (it will contain all the data). efficy functions as default value.

dsgn_postgreSQL-server-specific

Enter the name and password of the owner of the new database.

don’t confuse the the administrator (”owner”) of the Efficy database with the DBA role

dsgn_database-owner

This owner becomes the administrator of the Efficy database (user code: ADMIN)!

dsgn_admin-user

changing the administrator’s password

Tip: you can make use of the Alias, Customer and Guest Manager to maintain the administrator/database owner and his/her log-in.

dsgn_alias-customer-guest-manager-create-edit-alias-change-login

dsgn_alias-application-login

Optionally enter the name and password for the dedicated database user who executes native SQL queries on the database.

dsgn_native-SQL-queries

Warning: any user with such a log-in and sufficient SQL experience can gain access to all database content. Given the security risk that implies, you should manage this option with care!

dsgn_database-user-native-SQL

Tip: you can make use of the Alias, Customer and Guest Manager to maintain this log-in. Select the database alias and click the button Native SQL Login on the default tab Database Aliases.

dsgn_alias-customer-guest-manager-native-SQL-login

dsgn_alias-manager-native-SQL-login2

Select what you want to copy – the full database (its structure and its data) or just the database structure.

dsgn_database-copy-subset

© 2006-2020 Efficy All rights reserved