Thank you. That video should have been out already, but has been delayed due to the recording not containing the restore process. And backup isn't backup unless you are sure it can be restored 🙈 next time I get some content creation time from my family i will look over the current state of the backup video and push it forward. Good that you pinged me, otherwise I would probably kept delaying it 👍
@@lindblomdev Thanks for the reply, yes particularly backup/restore process in posgresql has been confusing to me as pgdump offers several options with sql and other formats and restore similar, has not been clear to me if there is a way to backup restore identical with sequences, functions, triggers etc all in place after restoring. Thanks will wait for the video.. Merry Christmas
I have noticed that sequences does get confused during restores. They shouldn't create duplicate numbers but on the next generation they produce holes. I didn't like that at first but then I realized that it didn't matter for me at all 🙃 maybe my backup video is to basic for you but it shows how I do it. If you have something to add after you have seen it, I'm interested. Sorry for being very slow to get this out, I've remade it many times in different ways, and still this is all I produced 😅 th-cam.com/video/NvZxLrVReXM/w-d-xo.html
hello Chris, great video. I followed through on the video , the i got an empty postgres config file, hence I couldn't make the correction of the "* " to allow access to the pgdb...kindly help
That has never happened to me. Are you sure your config file is in the same location? If you are using pg 14, then you should have a 14 in the path instead. As the file is completely empty, I'm suspecting that the path is wrong.
I am trying to connect to the server in pg admin 4 and I keep getting this error - Unable to connect to server: connection to server at [my GCP external IP address], port 5432 failed: timeout expired. I updated the postgresql.conf and pg_hba.conf files as shown in the video. Do you know what might be causing this?
Then I'm out of ideas right now. It was a while since I made the video. Maybe things have change a little bit since then in Google cloud. My server has been running for free since without any issues so I haven't had any reason to fiddle with it.
Great Tutorial ! After entering the code to install the database in the SSH browser tab, an error tells me that i've held broken packages, do you know a solution to this error by any chance? :)
No. It's for until they change the terms, I think it has been like this for years and I haven't read anything about them removing it. But make sure that you read the free tier configuration and match it exactly to get it for free. Mine is still running since I created it in this video.
@@lindblomdev thank you for the answer, I follow the video until you connect the database using test as maintenance and testuser. I get an error saying that test database doens't exist. If I change test for postgres it connects just fine. Any clue why it happens? Thanks!
It because you don't have a test database. Putting postgres is ok. You can use any database that exists in the cluster. Sorry for late reply. It's hard to see comments in youtube I think. :/
Great and straight forward video. Waiting for the follow up backup video.. thanks
Thank you. That video should have been out already, but has been delayed due to the recording not containing the restore process. And backup isn't backup unless you are sure it can be restored 🙈 next time I get some content creation time from my family i will look over the current state of the backup video and push it forward. Good that you pinged me, otherwise I would probably kept delaying it 👍
@@lindblomdev Thanks for the reply, yes particularly backup/restore process in posgresql has been confusing to me as pgdump offers several options with sql and other formats and restore similar, has not been clear to me if there is a way to backup restore identical with sequences, functions, triggers etc all in place after restoring. Thanks will wait for the video.. Merry Christmas
I have noticed that sequences does get confused during restores. They shouldn't create duplicate numbers but on the next generation they produce holes. I didn't like that at first but then I realized that it didn't matter for me at all 🙃 maybe my backup video is to basic for you but it shows how I do it. If you have something to add after you have seen it, I'm interested. Sorry for being very slow to get this out, I've remade it many times in different ways, and still this is all I produced 😅 th-cam.com/video/NvZxLrVReXM/w-d-xo.html
Hello Thanks for video I have
issue with connection to postgres no encryption (SQLSTATE 28000) Can you help me?
If you are using Google cloud like in this video. You might have an issue with their firewall, or the local firewall in Linux?
hello Chris, great video. I followed through on the video , the i got an empty postgres config file, hence I couldn't make the correction of the "* " to allow access to the pgdb...kindly help
That has never happened to me. Are you sure your config file is in the same location? If you are using pg 14, then you should have a 14 in the path instead. As the file is completely empty, I'm suspecting that the path is wrong.
@@lindblomdev you are correct i installed postgres 13, hence that changed the path from the one you used. Thanks
I am trying to connect to the server in pg admin 4 and I keep getting this error - Unable to connect to server: connection to server at [my GCP external IP address], port 5432 failed: timeout expired. I updated the postgresql.conf and pg_hba.conf files as shown in the video. Do you know what might be causing this?
There might be a firewall that you need to allow connections from all hosts?
And did you restart the service after you change which ip you bind to and how you are allowed to connect?
@@lindblomdev Thanks for the response, I set up the firewall like the video shows and I did restart the postgres service after updating the files.
Then I'm out of ideas right now. It was a while since I made the video. Maybe things have change a little bit since then in Google cloud. My server has been running for free since without any issues so I haven't had any reason to fiddle with it.
If you figure it out, please report back to help other people who ends up in the same situation.
Great Tutorial ! After entering the code to install the database in the SSH browser tab, an error tells me that i've held broken packages, do you know a solution to this error by any chance? :)
My guess from the top of my head is that you have a newer version of postgres? Maybe a path contains 15 now instead of 13?
@@lindblomdev You are right, that solved my problem, thank you so much !
no problem 😎👍
Hi Christopher, thanks for the video. A question, the free google tier is for a limited time?
No. It's for until they change the terms, I think it has been like this for years and I haven't read anything about them removing it. But make sure that you read the free tier configuration and match it exactly to get it for free. Mine is still running since I created it in this video.
They also have this thing where you get some credit to use the first year, but that is something else.
@@lindblomdev thank you for the answer, I follow the video until you connect the database using test as maintenance and testuser. I get an error saying that test database doens't exist. If I change test for postgres it connects just fine. Any clue why it happens? Thanks!
It because you don't have a test database. Putting postgres is ok. You can use any database that exists in the cluster. Sorry for late reply. It's hard to see comments in youtube I think. :/