General Inquiries
|
Knowledge Base
|
Submit Trouble Ticket
Knowledge Base - FAQ
PostgreSQL
Search:
Do you have a web interface tool for PostgreSQL?
We sure do. You can access it via the members section or you can use the following link:
https://www.kattare.com/psqladmin/
Question:
Who can see it:
Everyone
Members Only
Admins Only
Category:
Select One...
Acceptable Use
Administration
CGI
Coldfusion
Dedicated Servers
Dial-Up
Domain Management
E-Mail
Getting Started
HTML Programming
JSP-Java Servlets
Mailing Lists
Mod_Perl Programming
MySQL
Network Engineering
Other Resources
PHP Programming
PostgreSQL
Pre Sales
Programming in General
Ruby Programming (incl Rails)
Shell Issues
SSL
Telephone System
-or- New Category:
How do I change my PostgreSQL password?
Connect to server:
psql -h <servername> -U <username> <database name>
Do the following command:
ALTER USER <username> WITH ENCRYPTED PASSWORD 'mynewpassword';
Then quit with '\q'.
Question:
Who can see it:
Everyone
Members Only
Admins Only
Category:
Select One...
Acceptable Use
Administration
CGI
Coldfusion
Dedicated Servers
Dial-Up
Domain Management
E-Mail
Getting Started
HTML Programming
JSP-Java Servlets
Mailing Lists
Mod_Perl Programming
MySQL
Network Engineering
Other Resources
PHP Programming
PostgreSQL
Pre Sales
Programming in General
Ruby Programming (incl Rails)
Shell Issues
SSL
Telephone System
-or- New Category:
How do I create a new database?
From the shell you can use the following command:
createdb -h postgres.kattare.com
... or
Use the web interface tool phpPgAdmin at:
https://www.kattare.com/psqladmin/
Question:
Who can see it:
Everyone
Members Only
Admins Only
Category:
Select One...
Acceptable Use
Administration
CGI
Coldfusion
Dedicated Servers
Dial-Up
Domain Management
E-Mail
Getting Started
HTML Programming
JSP-Java Servlets
Mailing Lists
Mod_Perl Programming
MySQL
Network Engineering
Other Resources
PHP Programming
PostgreSQL
Pre Sales
Programming in General
Ruby Programming (incl Rails)
Shell Issues
SSL
Telephone System
-or- New Category:
[
Submit a Question
]
Indicates a question that only Kattare members can view. (For security reasons, sorry.)
Member Login
Username:
Password: