rsprog

Hi, I would like to request that my domain name be removed from Stevie so that I can move it over to Tommy. Thank you.

domain name: rsprog.net

 

It appears that PostgreSQL on Tommy is configured not to even accept local connections.

Does it work now?

 

Yes, its working great now. Thanks.

 

so that I can restore my database from a Stevie dump.

Did you know you can use phppgadmin https://tommy.heliohost.org:2083/3rdparty/phpPgAdmin/index.php to import your database dump? You don't need remote access to do that, but I'd be happy to grant it if you post

• database username
• database
• remote ip

 

Well, the dump I was trying to import had COPY commands (instead of INSERT), which made it impossible to import using phpPdAdmin, but I managed to get around that by installing Postgresql locally, importing the data there, and then doing a plain sql export. So I managed to recreate my database on Tommy. However, there is a similar problem now when trying to connect to the database from a php script:

pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "lazarus", database "lazarus_portfolio", SSL off

It appears that PostgreSQL on Tommy is configured not to even accept local connections. I'm connecting to localhost. This script worked on Stevie.

Hi, I am trying to connect remotely to Tommy's PostgreSQL database via pgAdmin, but I receive an error message "FATAL: no pg_hba.conf entry for host...". I remember this worked on Stevie, and, from looking at past posts, it didn't work on Johnny until someone fixed it. So please also enable remote access on Tommy so that I can restore my database from a Stevie dump. On Tommy my user name is lazarus. Thank you.

Below is a link to a thread that outlined the same problem and resolution on Johnny:

http://www.helionet.org/index/topic/22531-solved-connection-to-johnny-via-pgadmin/

Hello, would it be possible to get a backup of my PostgreSQL databases from Stevie? Account: rsprog

Thank you.

Hello, please also backup PostgreSQL databases if you get a chance, I really need that data and my most recent backup is apparently four years old . Thank you.

Can you try removing and re-adding all your users through cPanel?

Well, I could but I wouldn't be able to set their privileges through cPanel so these new users would be rather useless.

On the IRC, somebody uncovered an issue with PostgreSQL: PhpPgAdmin fails to login.

 

I can use pg_connect() in PHP fine though.

Yes, pg_connect() works fine. It seems the login problem with phpPgAdmin is unrelated to the privileges issue I run into when connecting with limited users.

Just to add to my original post, the user I used to connect to my database with pg_connect() was a user with limited privileges, and apparently the CONNECT privilege is a new privilege that wasn't necessary before. When I changed the connection settings to use the default user for my account then I was able to connect fine. So the only real issue is not being able to access phpPgAdmin for whatever reason. Once I have access to that, I can grant the CONNECT privilege to all the users I have.

Hello, I'm having trouble connecting to and accessing my PostgreSQL database on Stevie. I read that it was recently upgraded, but I have not been able to connect to it with my web page or through cPanel's phpPgAdmin. In phpPgAdmin I receive a "login failed" error. When testing with php, pg_connect() returns a "permission denied" exception with "User does not have CONNECT privilege." It was working fine before the upgrade.