Below is a Linux script I wrote that will drop and create all of the indexes for your database with the “concurrently” parameter. #!/bin/sh dbhost=localhostdatabase=somedatabasenamedbschema=/tempfile/dbschema.txtfiltered=/tempfile/dbschema_filtered.txtsql=/tempfile/rebuild_indexes.sql rm "$dbschema"rm "$filtered"rm "$sql" pg_dump -s -h "$dbhost" "$database" > "$dbschema"
Below is a Linux script I wrote that will drop and create all of the indexes for your database with the “concurrently” parameter.
#!/bin/sh
dbhost=localhost
database=somedatabasename
dbschema=/tempfile/dbschema.txt
filtered=/tempfile/dbschema_filtered.txt
sql=/tempfile/rebuild_indexes.sql
rm "$dbschema"
rm "$filtered"
rm "$sql"
pg_dump -s -h "$dbhost" "$database" > "$dbschema"
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных