However, those are deprecated, and the .pgpass is considered the
preferred method.
On Tue, Jul 27, 2010 at 3:56 PM, Walter Willmertinger wrote:
> You can set user and password with environment variables (PGUSER and
> PGPASSWORD) , also in a Windows batch or program.
> SET PGPASSWORD=xxxyyyzzz
> p
On Tue, Jul 27, 2010 at 15:58, Irene Barg wrote:
> I'm afraid I don't understand how turning on 'log_temp_files' will help?
Well, postgres is probably doing exactly what its told. You just need
to figure out what that is and why. ( and if it is some kind of bug,
we wont be able to do anything ab
Alex,
It's funny how one cannot see what is right in front of them. I did NOT
notice that 'var' was mounted as '/var/log', so postgres was getting
installed in root '/'. So I moved pgsql to /data1, and created a symlink
in /var/lib/pgsql to /data1/pgsql.
Now I have a pgsql_tmp file that has
You can set user and password with environment variables (PGUSER and
PGPASSWORD) , also in a Windows batch or program.
SET PGPASSWORD=xxxyyyzzz
psql -U "dbadmin" -d mydb -f D:\script.sql
Regards
Walter
On Tue, Jul 27, 2010 at 6:53 PM, wrote:
>
> Hi,
> I created several SQL that are automat
Lazarin Toni wrote:
> * Estimated time for postgresql latest RDBMS software instalation
> and configuration (does it takes longer on windows or on linux)
That depends. On a kubuntu system which didn't have PostgreSQL
installed, I typed:
sudo apt-get install postgresql
I had a running c
On 7/27/10 3:37 AM, Lazarin Toni wrote:
I am Oracle DBA and i will be maybe work on a project where postgresql
database will be used.
So i would be greatful if you could please advise me on the folowing :
· Estimated time for postgresql latest RDBMS software instalation and
configuration (does
Hello,
I am Oracle DBA and i will be maybe work on a project where postgresql database
will be used.
So i would be greatful if you could please advise me on the folowing :
* Estimated time for postgresql latest RDBMS software instalation and
configuration (does it takes longer on window
On Tue, Jul 27, 2010 at 12:16 PM, wrote:
>
> Thanks Kevin,
> Which of these 2 methods is the best practice?
>
> It is working with pgpass.
> But not yet with hba.conf
> I tried this without success.
> host all all 127.0.0.1/32 trust
You have to reload / restart the pg
"Joshua D. Drake" wrote:
> Best practice? Use .pgpass, not trust.
I would take ident over either in Linux; but the OP is on Windows
and I don't know if that's an option or, if so, how safe it is.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to yo
On Tue, 2010-07-27 at 14:16 -0400, steve.tout...@inspq.qc.ca wrote:
>
> Thanks Kevin,
> Which of these 2 methods is the best practice?
>
> It is working with pgpass.
> But not yet with hba.conf
> I tried this without success.
> hostall all 127.0.0.1/32 trust
>
Thanks Kevin,
Which of these 2 methods is the best practice?
It is working with pgpass.
But not yet with hba.conf
I tried this without success.
hostall all 127.0.0.1/32 trust
steve
"Kevin Grittner"
27/07/2010 01:17 PM
A
,
cc
Objet
Re: [ADMIN] psql shell with
Excerpts from Lou Picciano's message of mar jul 27 11:23:50 -0400 2010:
> Has anyone had any luck building pl/PHP on PostgreSQL v9 betas? Any
> tips/gotchas?
It works for me -- just compiled with with 9.0 beta3 and regression
tests pass fine.
> Is this language extension immensely successful/po
wrote:
> The script prompt for a password for user dbadmin.
> How to avoid that? I guess there is a config so dbadmin will
> "trust" this new user
You can use pg_hba.conf or pgpass:
http://www.postgresql.org/docs/current/interactive/auth-pg-hba-conf.html
http://www.postgresql.org/docs/
Hi,
I created several SQL that are automatically executed via windows task
scheduler, here is an example
psql -U "dbadmin" -d mydb -f D:\script.sql
It was running well until I changed the user (to open a session)
associated to these task.
The script prompt for a password for user dbadmin.
How to
On Tue, 2010-07-27 at 14:03 +, ALEXANDER JOSE wrote:
> I wonder if anyone has experience in installing postgresql on windows
> 7 that is the most appropriate version?
http://www.postgresql.org/download/windows
8.4.4
>
>
>
> Atentamente
>
> Alexander Angel
> Venezuela
>
>
> _
On Tue, 2010-07-27 at 15:23 +, Lou Picciano wrote:
> Has anyone had any luck building pl/PHP on PostgreSQL v9 betas? Any
> tips/gotchas?
> Is this language extension immensely successful/powerful, marginal, or
> not-so-good? Should we steer clear? TIA, Lou
Not sure if we have testing on v
Has anyone had any luck building pl/PHP on PostgreSQL v9 betas? Any
tips/gotchas?
Is this language extension immensely successful/powerful, marginal, or
not-so-good? Should we steer clear? TIA, Lou
Benjamin,
We're using the contrib module citext for all text columns so that we can
do case insensitive searches and so far we haven't found any that it
doesn't find.
Best Regards
Mike Gould
"Benjamin Krajmalnik" wrote:
>
>
>I just used the upper(text) function on a database which i
I wonder if anyone has experience in installing postgresql on windows 7 that is
the most appropriate version?
Atentamente
Alexander Angel
Venezuela
_
Discover the new Windows Vista
http:
19 matches
Mail list logo