Search the Community
Showing results for tags 'PostgreSQL'.
-
I cant connect to postgresql remotely, It shows: no pg_hba.conf entry for host necesarily only root can give that permission ? How can i fix that without the help's root. thanks.
-
Hi, complete db administration newbie here. I created a postgres db "cprn_luetest", created user "cprn_admin", added user to db, synced grants, set this user/pass in app. App created a table "user" with owner "cprn_admin" but now I need to remove it so it could be recreated with updated schema. The problem is I cannot remove this table from phpPgAdmin because it logs me in as "cprn" and refuses to execute DROP saying: SQL error: ERROR: must be owner of relation user In statement: DROP TABLE "public"."user"In table level privileges I only see default grants: Role CREATE USAGE Grantor postgres Yes Yes postgres Yes Yes postgresIn public privileges I tried to add something useful but it didn't help: Role CREATE TEMPORARY CONNECT Grantor No Yes Yes cprn_luetest cprn_luetest Yes* Yes* Yes* cprn_luetest cprn_admin Yes Yes Yes cprn_luetest cprn Yes* Yes* Yes* cprn_luetestWhat do I need to add and how to get god-like powers and be able to destroy everything (literally) in my db from phpPgAdmin?
-
I have the problem that I can't connect remotely to the postgres database I've made My connection parameters are database: gabriele_postgresuser: gabriele_gianninahost: johnny.heliohost.orgThen the connection responds: psql: FATAL: no pg_hba.conf entry for host "your ip", user "gabriele_giannina", database "gabriele_postgres", SSL off I need help. Thanks
-
Hi I need remote access to the postgresql database from any ip. Server: johnny.heliohost.org Postgresql user: "penosu_main" Postgresql database: "penosu_nueva" Thank you in advance Gonzalo
-
Hello! Please help me to enable remote access to my PostgreSQL.User: tu3sd4yDatabase: tu3sd4y_triply_dataServer: johnny.heliohost.orgThanks
-
Hi everyone, I can remotely access my postgresql db with url 'jdbc:postgresql://johnny.heliohost.org:5432/name_of_db' but, if I would have war file deployed on johny server together with PostgreSQL, how will this url change? It will stay the same? Or instead of 'johnny.heliohost.org' should be 'localhost'? Thanks in advance
-
I have been used Tommy server a year and use postgreSQL database under PHP web. Recently i changed my domain from .tk to .red and I'm experiencing problems with functions pgsql in PHP. The principal: After closing a pgsql connection with: pg_close($dbconn); the php die and stops all with this instruction even if the connection with db is successfull. Before change my domain, this issue did not appear. an example: https://www.laparcela.red/control/test.php After "Conectado con éxito" there are a echo "Hola mundo" and not appears. This also happens if the connection is not correct. $dbconn = pg_connect("host=localhost .. etc) or die("No se pudo conectar"); echo "Conectado con éxito"; pg_close($dbconn); echo '<p>Hola Mundo</p>'; or die not works.
-
Hello, my walter21_walter user is not able to query on tables with schema that is not public, I was only able to access tables within the public schema, even granting privileges to that user in other schemas, I want to know if I have to put the user walter21_walter as owner for all tables of all schemas?
-
I'm trying to access my postgresql database at johnny.heliohost.org Username is ukalumni_gpgauser and database name is ukalumni_gpga, but I'm getting the "FATAL: No pg_hba.conf entry for host xxx.xxx.xxx.xxx, user ukalumni_gpgauser, database ukalumni_gpga, SSL off. The only thing I've seen in the message archives is that you guys have to provide access for me. If there is a way to do this myself, I've missed it. Thank you, --Michael
-
Dear HelioNet I have the problem that I can't connect remotely to the postgresql database I've made My connection parameters are database: hadinih_md user: hadinih_user host: johnny.heliohost.org The connection responds: psql: FATAL: no pg_hba.conf entry for host "your ip", user "hadinih_user", database "hadinih_md", SSL off I need help. Thanks -
Hello, I need remote access to my PostgreSQL database for all IP's. My connection parameters are: database: jkdierno_sirio user: jkdierno_siriodb host: ricky.heliohost.org Thank you.
-
Hello, I have a question about drivers on johnny. I am new here and tried this hosting for my school work. I am using Nette with PDO connection to database and after testing i just got a error that postgre driver cannot be found, soo i want to ask you if problem is on my side or driver for pdo is not supported ? Thanks for reply.
-
Hello everybody, could you please setup the following remote connection? Postgresql Database name - cecacons_guidettitecaPostgresql username - cecaconsIP access - I would like to be able to access it from all IPs I am available for further questions, in case the given info is not enough. Best regards, Thottelberro -
Hi, May you change the configuration of PostgreSQL to connect remotely, please? Host: luizgava.heliohost.orgUser: luizgava_fitastic DB1: luizgava_agenda_fitastic All IPs Thanks.
-
Hi, Can you change the configuration of PostgreSQL to connect remotely? please. phpPgAdmin does not load well the backups. Host: ricky.heliohost.org User: dkm DB1: dkm_darkom IP: 35.202.115.72 Thanks
-
Hello everybody, Could you please setup the following remote connection? Host: ricky.heliohost.org DB1: steviehc_ventasDB2: steviehc_bdUsername: steviehc IP: 35.202.115.72 I am available for further questions, in case the given info is not enough. Best regards, David
-
Have a nice day. I have the problem that I can't connect remotely to the postgres database I've made My connection parameters are database: ilich_secultura user: ilich_secultura_user host: johnny.heliohost.org And the command from debian I'm using is: psql -h johnny.heliohost.org -p 5432 -U ilich_secultura_user -W pwd -d ilich_secultura Then the connection responds: psql: FATAL: no pg_hba.conf entry for host "your ip", user "ilich_secultura_user", database "ilich_secultura", SSL off I need help. Thanks **edit: host is johnny NOT jhonny. But still not working
-
Hi everyone, When I try to access with pgAdmin I get: "Unable to connect to server: FATAL: no pg_hba.conf entry for host "200.45.???.???", user "overflow_heroku", database "overflow_mastodonargentina", SSL off" Message. I suposse I need external access to my PostgreSQL database, could you give me please? All incoming IPs Database: overflow_mastodonargentina User: overflow_heroku Thank you in advance
-
Can i have remote access from any IP? Server: Tommy Database: dtopalov_web User: dtopalov_admin
-
I'm requesting access to my postgresql database in tommy server via pgadmin 4 for any ip that tries to connect to: database: iaconweb_pgdb username: iaconweb_pguser1 Also i need to restore a backup file to my postgres database. Can i do this myself or do need your help for this? I couldn't find any way to do this in phpPgAdmin Please let me know if you need any other info or I"m missing something. Thank you
-
This is the error: Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "inmobiliaria", SSL off in /home/inver/public_html/inmobiliaria/consulta.php on line 12 This is the file that connects to the database. Although locally it works. <?php /*Conexion a la base de datos*/ $user = "inver_inverdata"; $password = "*******"; $dbname = "inver_inmobiliaria"; $port = "5432"; $host = "localhost"; $cadenaConexion = "host=$host port=$port dbname=$dbname user=$user password=$password"; $conexion = pg_connect($cadenaConexion) or die("Error en la Conexión: ".pg_last_error()); /*$query = "select id, usuario, contrasenia from usuario"; $resultado = pg_query($conexion, $query) or die("Error en la Consulta SQL"); */ ?> -
Hey all, I would like to remote access my PostgreSQL database from any IP . I read in this forum that the remote access can be enabled for a user. For this reason I ask, if it can be enabled for me too? Btw I am on the johnny server. Databas name: fluctus_myDb Postgresql username : fluctus_Flctus Thank you in advance. Edit : I am sorry for the wrong tag. It was a mistake and now I don't know how to change it.
-
I use postgres for all my databases which its support is a very big attraction to pass me to this host. I think postgres on the jhonny server is misconfigured since the first error message I get when I make the call to the base is from pga_hba.conf pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", I hope they solve it, thank you very much. Greetings.
-
Hello! First of all, thank all of you very much for the awesome service! I want to know how big does a database have to be to be considered "too much"? I have a database with a few million entries, and I don't know if I am allowed to try and upload it to HelioHost. If I am allowed, I would be using PostgreSQL, but it would be nice to know if there is any difference between MySQL and PostgreSQL in regards to the resources. I could port the database to MySQL if that would be better. Thanks again!
-
I have the following configuration to connect to the database: $db_username = 'user=myuser'; $db_password = 'password=mypass'; $db_name = 'dbname=test'; $db_host = 'host=localhost'; $db = pg_connect("$db_host $db_username $db_password $db_name"); $query = "SELECT * FROM cities"; $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . "<br/>"; echo pg_last_error(); exit(); } $myrow = pg_fetch_assoc($result); $city = $myrow[city]; echo $city; The previous code works and it prints the name of the city in the table cities. Now If I try with the same but another table(Menu) which also have the field city I get the following error: Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation menu in /home1/user/public_html/index.php on line 9 Problem with query SELECT * FROM menu ERROR: permission denied for relation menu Both tables are under the same database (test) which was created by the same user. I don't know if I need to grant access to each table to the user and how or why am I getting this error. (When I run this in my computer it works but once I uploaded to the web that the error I'm getting) Any help would be highly appreciated.
