Bug 149249 - Allow to select database name other than template1 on connecting to PostgreSQL
Summary: Allow to select database name other than template1 on connecting to PostgreSQL
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: General (show other bugs)
Version: unspecified
Platform: unspecified Linux
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-08-27 08:42 UTC by mateusz-lists
Modified: 2016-11-01 21:44 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description mateusz-lists 2007-08-27 08:42:22 UTC 
Version:           3.5.7 (using KDE KDE 3.5.7)
Installed from:    Unlisted Binary Package
Compiler:          gcc 3.3 
OS:                Linux

I would like to be able to connect to postgresql even when you are not able to connect to template1 db.

Example:

$ psql -h pghost.vpn template1 username
Password for user username:
psql: FATAL:  permission denied for database "template1"
SZCZEGÓŁY: User does not have CONNECT privilege.
$ psql -h pghost.vpn mydb username
Password for user username:
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

mydb=> \q

Regards and thanks in advance.