The below script will look for a string in every column of the database. To start off with, Log in to postgres and make sure that you have selected the database. create a function by running the below script. (copy and paste as it is) Now, run the below command,…
Read MoreCategory: postgres
Content library hack(DB)
DB postgres
VMware Content library, A unique way to make VM templates/ISO’s available across multiple vCenter’s. However, It does not handle Datacenter segregation very well when storing the contents on NFS/VMFS. A subscribed library would need dedicated storage space and would be pointless in my setup as I had presented the NFS…
Read MorePostgreSQL: could not open file “/var/lib/pgsql/data/pg_clog/0726”: No such file or directory
postgres
when selecting a specific date from a table, at times due to database corruption Postgres might report the file was not found. In Such instances, we will can re-create the file using the below dd command (note: data loss on the missing file) Note: Ensure the permissions on the file…
Read MoreConnecting to VMware appliance postgres/PSQL instance from an external computer/pgadmin
postgres
By default, the postgres instance on vCenter/vSphere replication..etc.. are configured to not accept connections from a computer on the network. On this post, I will show you how to re-configure this to allow connections from an external box for tools like PGadmin etc. Note: Depending on the appliance, the postgres,…
Read More