pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
8+ messages / 8 participants
[nested] [flat]
* (no subject)
@ 2000-01-07 12:20 Luis Bezerra <luis@secrel.com.br>
0 siblings, 0 replies; 8+ messages in thread
From: Luis Bezerra @ 2000-01-07 12:20 UTC (permalink / raw)
To: pgsql-admin
unsubscribe pgsql-admin
--
-----------------------------
Luís Bezerra de A. Junior
luis@secrel.com.br
SecrelNet Informática LTDA
Fortaleza - Ceará - Brasil
Fone: 021852882090
-----------------------------
^ permalink raw reply [nested|flat] 8+ messages in thread
* (No Subject)
@ 2000-06-28 13:17 Oakley <oakerz@eudoramail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Oakley @ 2000-06-28 13:17 UTC (permalink / raw)
To: pgsql-admin
Being new to the databasing world, I have did quite a bit of research on the different ones available and decided to go with Postgres. I am
working on a system that has to have 3rd level
normalization.. As one might be able to tell since I am emailing all of you for your help, I
am having a problem... I cant get it to log
anything other than when the DB comes up, or
goes down...
When I did the configure, I did it with
--enable-syslog and with the --without-CXX
options. I read the online docs and created a
file in the /usr/local/pgsql/data directory
called postgresql.conf, and put in the options
I wanted, those being:
# --------
syslog = 2
debug_level = 2
log_connections = yes
log_timestamp = yes
port = 5432
# --------
As you might be able to tell from the options
above, I am wanting to keep track of connections
and the time that people connect up to the DB
and what they execute, etc...
Can anyone help? I would greatly appreciate it!
Mike
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* <no subject>
@ 2003-04-09 07:28 hetzel.devel@web.de
2003-04-09 07:33 ` Re: <no subject> Victor Yegorov <viy@pirmabanka.lv>
2003-04-09 09:44 ` Re: <no subject> A.Bhuvaneswaran <bhuvansql@myrealbox.com>
0 siblings, 2 replies; 8+ messages in thread
From: hetzel.devel@web.de @ 2003-04-09 07:28 UTC (permalink / raw)
To: pgsql-admin
Hello,
I'm using PostgreSQL on my Intranet-Server.
To make postgres more secure the entry in the pg_hba.conf for local users is:
local all md5
If I want to make a dump with pg_dump, I have to insert the password.
But I can't make a Cron-Job because I always have to insert the password!!
Is there any way to do this automatic?
H. Etzel
______________________________________________________________________________
UNICEF bittet um Spenden fur die Kinder im Irak! Hier online an
UNICEF spenden: https://spenden.web.de/unicef/special/?mc=021101
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: <no subject>
2003-04-09 07:28 <no subject> hetzel.devel@web.de
@ 2003-04-09 07:33 ` Victor Yegorov <viy@pirmabanka.lv>
1 sibling, 0 replies; 8+ messages in thread
From: Victor Yegorov @ 2003-04-09 07:33 UTC (permalink / raw)
To: hetzel.devel@web.de; +Cc: pgsql-admin
* hetzel.devel@web.de <hetzel.devel@web.de> [09.04.2003 10:31]:
> Hello,
> I'm using PostgreSQL on my Intranet-Server.
> To make postgres more secure the entry in the pg_hba.conf for local users is:
>
> local all md5
>
> If I want to make a dump with pg_dump, I have to insert the password.
> But I can't make a Cron-Job because I always have to insert the password!!
> Is there any way to do this automatic?
Yes. Use ~/.pgpass file. Search docs for more info on file format and other
details.
And next time, please, specify subject of your message.
--
Victor Yegorov
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: <no subject>
2003-04-09 07:28 <no subject> hetzel.devel@web.de
@ 2003-04-09 09:44 ` A.Bhuvaneswaran <bhuvansql@myrealbox.com>
2003-04-18 18:56 ` Re: <no subject> Andrew Biagioni <andrew.biagioni@e-greek.net>
1 sibling, 1 reply; 8+ messages in thread
From: A.Bhuvaneswaran @ 2003-04-09 09:44 UTC (permalink / raw)
To: hetzel.devel@web.de; +Cc: pgsql-admin
> local all md5
>
> If I want to make a dump with pg_dump, I have to insert the password.
> But I can't make a Cron-Job because I always have to insert the password!!
> Is there any way to do this automatic?
PGPASSWORD environment variable can be used.
regards,
bhuvaneswaran
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: <no subject>
2003-04-09 07:28 <no subject> hetzel.devel@web.de
2003-04-09 09:44 ` Re: <no subject> A.Bhuvaneswaran <bhuvansql@myrealbox.com>
@ 2003-04-18 18:56 ` Andrew Biagioni <andrew.biagioni@e-greek.net>
0 siblings, 0 replies; 8+ messages in thread
From: Andrew Biagioni @ 2003-04-18 18:56 UTC (permalink / raw)
To: A.Bhuvaneswaran <bhuvansql@myrealbox.com>; +Cc: hetzel.devel@web.de; pgsql-admin
From PostgreSQL 7.3.1 Documentation, section 1.10. Environment Variables:
PGPASSWORD sets the password used if the backend demands password
authentication. _This functionality is deprecated for security reasons_;
consider migrating to use the $HOME/.pgpass
<libpq-files.html#PGPASSFILE> file.
See Victor Yegorov's response (he also recommends .pgpass) and section
1.11. Files for details.
Andrew
A.Bhuvaneswaran wrote:
>>local all md5
>>
>>If I want to make a dump with pg_dump, I have to insert the password.
>>But I can't make a Cron-Job because I always have to insert the password!!
>>Is there any way to do this automatic?
>>
>>
>
>PGPASSWORD environment variable can be used.
>
>regards,
>bhuvaneswaran
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* (no subject)
@ 2004-07-09 02:02 Pedro B. <pedro.borracha@netcabo.pt>
0 siblings, 0 replies; 8+ messages in thread
From: Pedro B. @ 2004-07-09 02:02 UTC (permalink / raw)
To: pgsql-admin
subscribe pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
* <no subject>
@ 2010-10-01 04:06 Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Tena Sakai @ 2010-10-01 04:06 UTC (permalink / raw)
To: pgsql-admin
Hi everybody,
I recently built postgres 8.4.4 from source and tested it.
It seemed to work fine then, but I cannot seem to run psql
today. I built it to run on port 6543. Do I need to specify the
port number when I start it?
Here’s the session dialog:
bash-3.2$ pg_ctl stop -D /usr/local/pgsql/data
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
waiting for server to shut down....LOG: database system is shut down
done
server stopped
bash-3.2$
bash-3.2$ pg_ctl start -D /usr/local/pgsql/data
server starting
bash-3.2$ LOG: database system was shut down at 2010-09-30 20:38:47 PDT
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
bash-3.2$
bash-3.2$ psql canon
psql: could not connect to server: Connection refused
Is the server running on host "172.16.0.151" and accepting
TCP/IP connections on port 6543?
bash-3.2$
Thank you for your help.
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2010-10-01 04:06 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-07 12:20 (no subject) Luis Bezerra <luis@secrel.com.br>
2000-06-28 13:17 (No Subject) Oakley <oakerz@eudoramail.com>
2003-04-09 07:28 <no subject> hetzel.devel@web.de
2003-04-09 07:33 ` Re: <no subject> Victor Yegorov <viy@pirmabanka.lv>
2003-04-09 09:44 ` Re: <no subject> A.Bhuvaneswaran <bhuvansql@myrealbox.com>
2003-04-18 18:56 ` Re: <no subject> Andrew Biagioni <andrew.biagioni@e-greek.net>
2004-07-09 02:02 (no subject) Pedro B. <pedro.borracha@netcabo.pt>
2010-10-01 04:06 <no subject> Tena Sakai <tsakai@gallo.ucsf.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox