you enabled remote access to the PostGres so why did you add the IP address to the client server under local connections instead of under remote connections?
Awesome tutorial but just suggestion brother. add captions (chapters) to all videos that will add readability and people can jump back to specific section if they want to. for e.g. I was looking for specific section in tutorial and if timing mentioned it's easy... you can include somethin like this in video description which creates chapeters " 0:00 Intro 1:20 section 1 "
Hello Yasin, Have you installed it on windows or Linux? As per error msg the PostgreSql binary location is not found. Please let me know is it windows or Linux?
I have followed all these instructions and I am still getting the same error of "Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Permission denied Is the server running on host "ecommerce-1" (fe80::xxx:xxxx:xxxx:xxxx) and accepting TCP/IP connections on port 5432? " I'm running a Linux server with Apache/2.4.10 (Fedora) PHP/5.5.26 and PostgreSQL 9.3.6
Hi, I have downloaded postgres on an ubuntu server using postgres docs the server is working but I didn't run the initdb command as it was not mentioned in the docs I can't find pg_hba.conf file
@@EMultiSkillsDatabaseServices Yes I was able to, I have changed the server from ubuntu to redhat to follow the tutorial exactly and I was able to run initdb and find the pg_hba.conf file but I ran into anothe problem After modifying both files, pg_hba.conf and postgresql.conf, it asked for a password to restart postgres service similar to 8:12 but the problem is that I am running the server on AWS and I don't have a password for my root user, so which password should I use here
@@EMultiSkillsDatabaseServices even while typing sudo systemctl start postgresql-12 it asks for password, I rebooted the aws instance and now the service is not started automatically and 'Active: failed (Result: exit-code)' I believe maybe AWS changes the IP address when the instance is rebooted
I am facing the issue while accessing the PostgreSQL Server remotely. I did all required changes whatever you provided. Still the issue is there. Is there any email address or contact number you have ? We can have a talk to get some help from you.
Thanks, herlped a lot ! some guys make it work with just psql -U postgres [ no -h + IP] wonder how they do I'm using the same PC as Client and Server machine, maybe thats the problem
If you have installed Postgres alredy, you would also need to add its "bin" folder in Environment variable. Otherwise run psql from the command prompt only where psql.exe lies
Just finished accessing my database from remote server on my dbeaver
It's a complex work but you explained it well
Thanks a lot !
Thank you...This was very helpfull ..Love from Indonesia
Numbers of videos are not coming in proper way. Hard to find part 5 and many more.
Thank you, well done and clear communication.
Thank you...This was awesome and very well explained..Love from Kenya
Thank you very much.
0pm,
you enabled remote access to the PostGres so why did you add the IP address to the client server under local connections instead of under remote connections?
Awesome tutorial but just suggestion brother.
add captions (chapters) to all videos that will add readability and people can jump back to specific section if they want to.
for e.g. I was looking for specific section in tutorial and if timing mentioned it's easy...
you can include somethin like this in video description which creates chapeters
"
0:00 Intro
1:20 section 1
"
I appreciate the point mentioned by you.
I will check the feasibility to include that.
nice!! Thank you very much
Thank you!
You are welcome.
Hey for example in .71 server i have this error psql not found
Hello Yasin, Have you installed it on windows or Linux?
As per error msg the PostgreSql binary location is not found.
Please let me know is it windows or Linux?
can you pls do the vedio for migration oracle to postgressql tutorial
I have followed all these instructions and I am still getting the same error of "Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Permission denied Is the server running on host "ecommerce-1" (fe80::xxx:xxxx:xxxx:xxxx) and accepting TCP/IP connections on port 5432? " I'm running a Linux server with Apache/2.4.10 (Fedora) PHP/5.5.26 and PostgreSQL 9.3.6
I m not sure, but i hope you have allowed access to the user or "all"
maybe your firewall application still is running. You should disable it
You can follow my steps above.
can you do a video on doing this using windows?
I will try to do that .
@@EMultiSkillsDatabaseServices ready yet for windows?
@@EMultiSkillsDatabaseServices yes man, much needed... I am struggling in GCP
GOOD
Thanks
Hi, I have downloaded postgres on an ubuntu server using postgres docs
the server is working but I didn't run the initdb command as it was not mentioned in the docs
I can't find pg_hba.conf file
are you able to login to psql ?
@@EMultiSkillsDatabaseServices Yes I was able to,
I have changed the server from ubuntu to redhat to follow the tutorial exactly and I was able to run initdb and find the pg_hba.conf file but I ran into anothe problem
After modifying both files, pg_hba.conf and postgresql.conf, it asked for a password to restart postgres service similar to 8:12 but the problem is that I am running the server on AWS and I don't have a password for my root user, so which password should I use here
You need to switch to sudo mode
@@EMultiSkillsDatabaseServices even while typing sudo systemctl start postgresql-12 it asks for password,
I rebooted the aws instance and now the service is not started automatically and 'Active: failed (Result: exit-code)' I believe maybe AWS changes the IP address when the instance is rebooted
I am facing the issue while accessing the PostgreSQL Server remotely. I did all required changes whatever you provided. Still the issue is there. Is there any email address or contact number you have ? We can have a talk to get some help from you.
Did it work for you ??
What if the client IP is dynamic?
Mention wider ranger of ip list
@@EMultiSkillsDatabaseServices Wider? Can you give me a example?
Thanks, herlped a lot ! some guys make it work with just psql -U postgres [ no -h + IP] wonder how they do I'm using the same PC as Client and Server machine, maybe thats the problem
I get this command not found: psql
has it been sorted out ? Did you check if the PostgreSQL was installed and started after that ?
If you have installed Postgres alredy, you would also need to add its "bin" folder in Environment variable. Otherwise run psql from the command prompt only where psql.exe lies