{{Latest Articles}}

PostgreSQL How-to Change Owner for All Tables

  • Ivan Ivanov
  • PostgreSQL
PostgreSQL How-to Change Owner for All Tables

When moving websites between servers the database user often changes. While it is easy to dump and restore database dumps using pg_dump and pg_restore this might lead to invalid table ownership's on the new host. This bash script will easily fix this issue.
/usr/local/bin/alter
#!/bin/bash
Read More

Hello World!

  • Ivan Ivanov
  • Blog
Hello World!

This blog has finally come to a time and is already a fact. I had started it more than a year ago, I even let it go for a day, but I did not get the courage and I stopped it. Maybe because I did not feel competent enough about the "Linux" & "Programming" topic, or maybe I did not have the time to [...]

Read More