Hi there,
What about a command line switch which allow the user to send password via
command line arg? For example:
./vacuumdb -U username -p password
This way vacuumdb can be run by cron without "trust"-ing any user in
pg_hba.conf.
I have patched PostgreSQL 8.0.3 source to allow password as
Tom Lane wrote:
> Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
>
>>attached is a patch against psql that makes psql's tabcomplete code
>>ROLES aware, adds SET SCHEMA and basic CREATE DATABASE/TRIGGER support
>>as well as some other minor things.
>
>
> Applied with some changes. I didn't see
At 2005-08-15 10:09:39 +0300, [EMAIL PROTECTED] wrote:
>
> ./vacuumdb -U username -p password
>
> This way vacuumdb can be run by cron without "trust"-ing any
> user in pg_hba.conf.
http://www.postgresql.org/docs/current/static/libpq-pgpass.html
-- ams
---(end of broadc
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> Any particular reason why you dropped the SET SCHEMA part of my
> patch ?
Because we have no such command.
regards, tom lane
---(end of broadcast)---
TIP 1: if posting/read
NosyMan <[EMAIL PROTECTED]> writes:
> What about a command line switch which allow the user to send password via
> command line arg?
You do realize that such a password could be seen by every other user on
the machine, using "ps"?
regards, tom lane
--
On Fri, 2005-08-12 at 21:53 -0400, Bruce Momjian wrote:
> This has been saved for the 8.2 release:
Just to clarify: the "SELECT INTO EXACT" patch was abandoned in favor of
the "#option select_into_1_row" patch. I submitted both patches as part
of the same -patches thread, but the latter solution,
Bruce Momjian wrote:
> I am thinking the proper term for the first column of pg_stat_file() is
> "size", not "length".
>
> test=> select * from pg_stat_file('.');
>length | atime | mtime |
> ctime | isdir
>
> +---
The message format for elog() report is cleaned up.
--
NAGAYASU Satoshi <[EMAIL PROTECTED]>
diff -cr pgsql.orig/src/backend/commands/tablecmds.c
pgsql/src/backend/commands/tablecmds.c
*** pgsql.orig/src/backend/commands/tablecmds.c 2005-06-28 14:08:54.0
+0900
--- pgsql/src/backend/comma
