Command Line Parameters
dbpgsqlvacuum /u <USER> /p <PASS> /t <TABLE> /c /l <DSN|ConnectionString>
Argument |
Description |
Required |
Default Value |
/s <HOSTNAME|IP> |
Hostname or IP address to connect to |
NO |
172.0.0.1 |
/b <PORT> |
TCP Port PostgreSQL server is listening on |
NO |
5432 |
/d <DATABASE> |
Database where TABLE is located |
YES |
|
/t <TABLE> |
SQL table (including schema) to perform full vacuum on |
YES |
|
/u <USERNAME> |
Username to connect as |
NO |
postgres |
/p <PASSWORD> |
Password for USERNAME |
YES |
|
|
When using a connection string, both username and password need to be specified inside the connection string, the /u and /p options cannot be used. |
Examples
Example 1: Perform a full vacuum on the eventsentry.eseventlogmain table in the EventSentry database
dbpgsqlvacuum /u postgres /p !$^&3jdk3 /d EventSentry /t eventsentry.eseventlogmain