Error creating PostgreSQL database
Error creating PostgreSQL database
Hi,
I just installed Vesta Panel and everything seems fine. Great software!
I need support for PostgreSQL so I followed the instructions in here:
https://vestacp.com/docs/#how-to-setup- ... ian-ubuntu
Everything went fine. Just had to logout and login to see psgql option in the combobox when creating a new db.
This was the error that came up after clicking "ADD":
"ERROR: pgsql host localhost doesn't exist"
Attached screenshot (wait to load):
What can I do?
Thank you
I just installed Vesta Panel and everything seems fine. Great software!
I need support for PostgreSQL so I followed the instructions in here:
https://vestacp.com/docs/#how-to-setup- ... ian-ubuntu
Everything went fine. Just had to logout and login to see psgql option in the combobox when creating a new db.
This was the error that came up after clicking "ADD":
"ERROR: pgsql host localhost doesn't exist"
Attached screenshot (wait to load):
What can I do?
Thank you
-
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: Error creating PostgreSQL database
I guess VestaCP is not able to sense and configure the PostgreSQL that you installed separately. Maybe someone has an idea to make them talk with each other.
You should have done and Advanced install with PostgreSQL checked. (--postgresql yes)
You should have done and Advanced install with PostgreSQL checked. (--postgresql yes)
Re: Error creating PostgreSQL database
Ok I dig a little bit...
This validation fails:
https://github.com/serghey-rodin/vesta/ ... in.sh#L223
So... even after following:
https://vestacp.com/docs/#how-to-setup- ... ian-ubuntu
Still, this file does not exists:
Can I just copy /usr/local/vesta/conf/mysql.conf to /usr/local/vesta/conf/pgsql.conf ?
Cheers
This validation fails:
https://github.com/serghey-rodin/vesta/ ... in.sh#L223
So... even after following:
https://vestacp.com/docs/#how-to-setup- ... ian-ubuntu
Still, this file does not exists:
Code: Select all
/usr/local/vesta/conf/pgsql.conf
Cheers
Re: Error creating PostgreSQL database
Ok, I copy mysql.conf to pgsql.conf (also .mysql.localhost to .pgsql.localhost) and edit to this:
Now I got success:
Cheers
Code: Select all
HOST='localhost' USER='postgres' PASSWORD='xxxxxxxx' TPL='template1' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='admin,xxxxxx' U_DB_BASES='4' SUSPENDED='no' TIME='16:34:32' DATE='2017-10-02'
I hope this can help other...Database xxxxxxxxx has been created successfully. / open phpPgAdmin
Cheers
-
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: Error creating PostgreSQL database
Great if it works for you.
I don't have hands-on experience with Postgres but I would suggest you to use & watch your system for a few days. Also check if the VestaCP backup scripts can successfully backup your DBs fine or not.
If VestaCP is able to manage PGSQL DBs fine, please mark the topic solved
I don't have hands-on experience with Postgres but I would suggest you to use & watch your system for a few days. Also check if the VestaCP backup scripts can successfully backup your DBs fine or not.
If VestaCP is able to manage PGSQL DBs fine, please mark the topic solved
Re: Error creating PostgreSQL database
OK I tried a backup and It is giving error:
Now I have to dig more... Any ideas? Thanks.Can't dump database afonsodev_map1
/usr/lib/postgresql/9.5/bin/pg_dump: invalid option -- 'i'
Try "pg_dump --help" for more information.
Re: Error creating PostgreSQL database
Following the v-backup-user command, I found the pgsql_dump in db.sh:
https://github.com/serghey-rodin/vesta/ ... /db.sh#L91
I'm using version 9.5 in Ubuntu 16.04 and there is no -i option.
EDIT: after removing this option, the user backup completed.
https://github.com/serghey-rodin/vesta/ ... /db.sh#L91
I'm using version 9.5 in Ubuntu 16.04 and there is no -i option.
EDIT: after removing this option, the user backup completed.