Sample Header Ad - 728x90

What is the meaning/benefit of this command: export PGOPTIONS="-P"

0 votes
1 answer
423 views
I see https://www.postgresql.org/docs/current/sql-reindex.html has
$ export PGOPTIONS="-P"
$ psql broken_db
...
broken_db=> REINDEX DATABASE broken_db;
broken_db=> \q
I see the below content, but I still did not understand. > Alternatively, a regular server session can be started with -P > included in its command line options. The method for doing this varies > across clients, but in all libpq-based clients, it is possible to set > the PGOPTIONS environment variable to -P before starting the client. > Note that while this method does not require locking out other > clients, it might still be wise to prevent other users from connecting > to the damaged database until repairs have been completed. What is the meaning/benefit of this command: export PGOPTIONS="-P"
Asked by David Lapetina (219 rep)
Jul 22, 2022, 01:07 PM
Last activity: Apr 13, 2025, 08:03 AM