gowatana/create-extension-pgvector.sh Secret

## create-extension-pgvector.sh
#!/usr/bin/bash
OUTFILE=$HOME/post_script.log
source ~/.bash_profile

echo "Check Env ---" >> $OUTFILE
env | grep PG >> $OUTFILE

sed -i '/^local.*all.*all/i local all postgres peer' $PGDATA/pg_hba.conf
sudo systemctl restart era_postgres
sleep 10

echo "Check $PGDATA/pg_hba.conf ---" >> $OUTFILE
cat $PGDATA/pg_hba.conf | grep -E -v "^#|^$" >> $OUTFILE

psql -V 2>&1 >> $OUTFILE
psql --dbname=vectordb --command='CREATE EXTENSION vector;'

exit 0
	#!/usr/bin/bash
	OUTFILE=$HOME/post_script.log
	source ~/.bash_profile

	echo "Check Env ---" >> $OUTFILE
	env \| grep PG >> $OUTFILE

	sed -i '/^local.all.all/i local all postgres peer' $PGDATA/pg_hba.conf
	sudo systemctl restart era_postgres
	sleep 10

	echo "Check $PGDATA/pg_hba.conf ---" >> $OUTFILE
	cat $PGDATA/pg_hba.conf \| grep -E -v "^#\|^$" >> $OUTFILE

	psql -V 2>&1 >> $OUTFILE
	psql --dbname=vectordb --command='CREATE EXTENSION vector;'

	exit 0