- Posts: 16
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
PostgreSQL from a different server
- kingmaker
- Topic Author
- Offline
- New Member
Less
More
9 years 8 months ago #111066
by kingmaker
PostgreSQL from a different server was created by kingmaker
Hello, here is the situation :
Please note that the dabase is of PostgreSQL.
While installing, it does not show PostgreSQL in the pre-installation and Configuration pages
I CANNOT change the database typr to PostgreSQl. I can fill in the details like Database location (Hostname which is xyz.com in my case), Database user, Database password, Database name. BUt connection error. Ofcourse that is expected.
The connection to the database server has to be done using port: 5434.
In short, I am not being able to install limeSurvey. How can I resolve this issue.
- I have a surver called ABC ( say abc.com is the address) and that is where I will have my limeSurvey installed.
- I have a dedicated Database server called "XYZ" and that is where I want the database to be fetched for my limeSurvey.
Please note that the dabase is of PostgreSQL.
While installing, it does not show PostgreSQL in the pre-installation and Configuration pages
I CANNOT change the database typr to PostgreSQl. I can fill in the details like Database location (Hostname which is xyz.com in my case), Database user, Database password, Database name. BUt connection error. Ofcourse that is expected.
The connection to the database server has to be done using port: 5434.
In short, I am not being able to install limeSurvey. How can I resolve this issue.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
9 years 8 months ago #111073
by DenisChenu
php.net//manual/en/ref.pdo-pgsql.php
Need to be installed and activated ( aptitude install php5-pgsql for example).
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic PostgreSQL from a different server
You need pdo_pgsql to connect to a postgre DB.While installing, it does not show PostgreSQL in the pre-installation and Configuration pages
php.net//manual/en/ref.pdo-pgsql.php
Need to be installed and activated ( aptitude install php5-pgsql for example).
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- kingmaker
- Topic Author
- Offline
- New Member
Less
More
- Posts: 16
- Thank you received: 0
9 years 8 months ago #111112
by kingmaker
Replied by kingmaker on topic PostgreSQL from a different server
I tried it, now I am being able to see the postGreSQl, but still I am not being able to connect.
Attaching the screenshot.
I have checked the connection to the database server and also the database mentioned using terminal, they are correct and they exist.
Not being able to figure out what has to be done now to get it working.
Attaching the screenshot.
I have checked the connection to the database server and also the database mentioned using terminal, they are correct and they exist.
Not being able to figure out what has to be done now to get it working.
Attachments:
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
9 years 8 months ago #111208
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic PostgreSQL from a different server
The port is OK ?
I think you can use DBHOST:port
Denis
I think you can use DBHOST:port
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.