Page 1 of 1

[SOLVED] - PostgreSQL and MySQL together possible ?

Posted: Sun Feb 06, 2005 11:57 pm
by anjanesh
I need to install PostgreSQL for a particular website.
Can any one tell me what this means ?

Image
What is this account name ? Will it create a separate windows login account ? If I dont install as service then how'll it work ? Manually run it on startup ?
Im using MySQL which I dont want to uninstall or stop. Is it possible for me to have both running at the same time ?
Also can phpMyAdmin pickup both the databases ?
Thanks

Posted: Mon Feb 07, 2005 12:02 am
by feyd
It tells you what account name is at the bottom of your screenshot:
This service account is the account that runs the PostgreSQL database server. It must NOT be a member of the local adminstrators group. If you have not already created an account, the installer can do so for you. Enter an account name and a password, or leave the password blank to have one auto-generated.
As for running MySQL at the same time, I don't see why that'd be a problem, they should function on seperate protocols and listening ports.

And no, phpMyAdmin is designed specifically for MySQL. If you did a search on google, you should have found this: http://sourceforge.net/projects/phppgadmin/

Posted: Mon Feb 07, 2005 12:09 am
by anjanesh
Because if its not windows account then whats this, just below the first image ?
Image
So if uncheck run as service how will it run as ?

Posted: Mon Feb 07, 2005 12:44 am
by feyd
it would have to be manually run, it'd then run as your user.
anjanesh wrote:Because if its not windows account then whats this, just below the first image ?
I don't understand what you're asking now.

Posted: Mon Feb 07, 2005 1:55 am
by anjanesh
After the Service Configuration it proceeds to Initialise databse cluster.
In both passwords are asked.

Service Configuration - If this is not Windows a/c then what kind of a/c is this ? It definitely not SQL Admin a/c because its there below.
Image
Initialise databse cluster - This is probably the Admin account as in MySQL
Image

Posted: Mon Feb 07, 2005 1:59 am
by feyd
The service configuration password is the password for the user the service will run under (Windows ACL)

The "Initialise database" one is the super user account password for managing the database itself.

Posted: Mon Feb 07, 2005 3:02 am
by anjanesh
Installed PostgresSQL as service.
Service Password and Superuser password are same (just for now so that I dont get confused)
It seems to be running because when I ran pgAdmin III and connected with password it got in showing Databases(0), Usera(1) etc. So I guess its working.
I also enabled the extension in php.ini.
But in http://localhost/phpPgAdmin, it asks for username, password, Server and Language.
I entered username as postgres (default at installation) and password, Server PostgreSQL (only option) and English but it keeps giving the msg :
Login disallowed for security reasons.
View online FAQ


Log file just shows :
2005-02-07 13:57:55 LOG: database system was shut down at 2005-02-07 13:57:43 India Standard Time
2005-02-07 13:57:55 LOG: checkpoint record is at 0/AC3330
2005-02-07 13:57:55 LOG: redo record is at 0/AC3330; undo record is at 0/0; shutdown TRUE
2005-02-07 13:57:55 LOG: next transaction ID: 546; next OID: 17230
2005-02-07 13:57:55 LOG: database system is ready

Any idea on how to get this working in phpPgAdmin since its working in pgAdmin III ?
Thanks

Posted: Mon Feb 07, 2005 4:55 am
by anjanesh
Ok. got this one solved.
Have to set $conf['extra_login_security'] = false;
default was true.

Posted: Mon Feb 07, 2005 10:48 am
by anjanesh
In MySQL the default location to store the db are in data dir of MySQL. The tables are in files with each table having 3 files with same name as tablename. Where are the dbs, tables in PostgreSQL ?
Thanks