On Tue, 9 Jul 2002, Tim Ellis wrote:
> I've always been a proponent of letting the OS do what it does best, so
> this letting-the-OS-buffer-for-you concept, to me, is very appealing.
Me too. :-) Especially since it's generally going to be doing some sort
of buffering anyway, and has a whole bunc
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of ashwini sridhar
> Sent: Tuesday, July 09, 2002 8:51 PM
> To
Kevin Brannen wrote:
> Bruce Momjian wrote:
> ...
> >
> > 7.3 may remove PGPASSWORD, I think, and instead allow you to specify a
> > file that contains the password.
>
> But do you know how many hours it took me to find out about PGPASSWORD
> in the docs and now you want to change that? :-)
>
Bruce Momjian wrote:
> becks wrote:
> > hello.
> > how to check disk space usage for a single table?
>
> Look at relpages in pg_class for that table. VACUUM the table first.
Actually, I wrote some stuff up for the 7.3 docs on this:
http://developer.postgresql.org/docs/postgres/diskusag
becks wrote:
> hello.
> how to check disk space usage for a single table?
Look at relpages in pg_class for that table. VACUUM the table first.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard dr
=
bbye - ashwini
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Yes, that's the idea, so that even in an abrupt power failure you should
be protected against data loss. It wont save any transactions in
progress and don't forget that abrupt power loss could corrupt your file
system itself, so a ups would still be nice to have for a more graceful
shutdown. If yo
On Mon, 8 Jul 2002, Arnis Stasko wrote:
> Is it posible to move data from Lotus to PgSQL.
> If is then how?
Hello
I am not very sure what you mean by 'Lotus' which I think of as a software
vendor, not a format or database or so.
If you refer to Lotus Notes, I have to admit that I cannnot help
yesterday, I have upgraded postgresql database from 7.2.0
to 7.2.1
version.
Before upgrading, I have took backup from 7.2.0 and
shudown the
database and
did initdb on posgresql 7.2.1. Then started the newer
version (7.2.1)
and restored the data from the backup. But when we run
some queries,
it is
The postmaster is being started "postmaster ... >>
/usr/local/pgsql/logfile 2>&1", and the messages are appearing in
/usr/local/pgsql/logfile. They do not appear in the syslog. I just
assumed it was Postgres doing this, but it must be a message the OS is
writing from the postmaster's proces
Bruce Momjian wrote:
...
>
> 7.3 may remove PGPASSWORD, I think, and instead allow you to specify a
> file that contains the password.
But do you know how many hours it took me to find out about PGPASSWORD
in the docs and now you want to change that? :-)
How about all 4 approaches: on the com
Hi,
I am not sure about the command line option, but the password for any user
can be set using ALTER USER sql command.
ALTER USER my_user ENCRYPTED PASSWORD 'my_pass';
also refer the documentation for details.
regards,
bhuvaneswaran.
On 8 Jul 2002, Stephane Schildknecht wrote:
> Hi,
>
>
hello.
how to check disk space usage for a single table?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
> > Is there not a method of reading a disk block and instructing the OS
> > not to buffer it, or am I hallucinating?
>
> Yes. Read the block from a raw device. Of course, it's up to you to deal
> with an filesystem issues or whatever. :-)
>
> FreeBSD also has the O_DIRECT flag, but that's not g
test
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
At 05:23 PM 7/9/02 +0200, Stefano Coletta wrote:
>I had problems when a power failure occurred on old postgres
>installations. I had to use pg_check to fix problems.
>
>Now I have installed an UPS just to make a clean shutdown of the system. I
>strongly suggest you to purchase an UPS, just to ma
[EMAIL PROTECTED] wrote:
> Hi
>
> can anybody tell how robust postgre is in case of power failure? Will I loos
> data or integrity? I am using an ext3 filesystem.
Robust. Only lose of data is disk failure.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTEC
I had problems when a power failure occurred on old postgres installations. I had to
use pg_check to fix problems.
Now I have installed an UPS just to make a clean shutdown of the system. I strongly
suggest you to purchase an UPS, just to make a clean shutdown.
Nimesh BakshiPh: 574-232-3900 Ext-218Fax:
574-287-5916
You can try with:
echo password | psql ...
But if you are using Pgsql 7.2.1 it will not work (in fact postgres 7.2.1 is getting
passwords from /dev/tty instead of stdin).
However I posted here in the admin-list a patch to the postgres 7.2.1 C code to make
it work with stdin, like the older ve
I've used expect before, thinking I might try out Jython now...
John
-Original Message-
From: Michael A. Schulte [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 09, 2002 4:52 AM
To: [EMAIL PROTECTED]
Subject: [ADMIN] psql in Batch mode and passwords?
Hi,
does anyone have an idea how to
Bob Smith <[EMAIL PROTECTED]> writes:
> I'm running Postgres 7.2.1 on Mac OS X Server 10.1.5, and the logfile is
> getting quite large because it logs this:
> bootstrap_look_up() failed (ipc/send) invalid destination port
Are you certain that message is coming from Postgres? I've never seen
it
On Mon, 8 Jul 2002, Dave Whitmarsh wrote:
> How do you get your own primary keys, especially multiple primary keys, to
> over ride the system key?
Well, you can't have multiple primary keys. You can have multiple
candidate keys with unique however.
It might be more helpful to say what you're d
On Tue, 9 Jul 2002, Auri Mason wrote:
> in order to measure the improve of performances after a vacuum+reindex (do
> you suggest something more?), I want to understand exactly the output of
> the explain command.
> After a google search I found a broken link posted by Tom.
As a suggestion, vacc
Felipe Nascimento wrote:
> Could you explain primary and secondary passwords?
> How can I create primary passwords?
Primary passwords are stored in pg_shadow. We will not even support
secondary passwords in 7.3 so don't worry about them. It was an old
idea to allow /etc/passwd to function in Po
Michael A. Schulte wrote:
> Hi,
>
> does anyone have an idea how to convince psql
> to accept a password that is passed during startup
> of psql in the command line?
>
> I don't want to modify pg_hba.conf so that it
> is open for everyone so I have inserted:
>
> local all
Hi
can anybody tell how robust postgre is in case of power failure? Will I loos
data or integrity? I am using an ext3 filesystem.
Thanks for your help!
Regards,
Andreas
---(end of broadcast)---
TIP 2: you can get off all lists at once wit
Dear admin,
How do you get your own primary keys, especially multiple primary keys, to
over ride the system key?
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
does anyone have an idea how to convince psql
to accept a password that is passed during startup
of psql in the command line?
I don't want to modify pg_hba.conf so that it
is open for everyone so I have inserted:
local all trust
host all
Is it posible to move data from Lotus to PgSQL.
If is then how?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Is it posible to move data from Lotus to PgSQL.
If is then how?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Title: RE: [ADMIN] createuser --password
Could you explain primary and secondary passwords?
How can I create primary passwords?
Is a lack of security using only this secondary passwords?
Tks
Felipe
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
Sent: segunda-fe
in order to measure the improve of performances after a vacuum+reindex (do
you suggest something more?), I want to understand exactly the output of
the explain command.
After a google search I found a broken link posted by Tom.
Anyone of you can help me?
TIA, Auri
I'm running Postgres 7.2.1 on Mac OS X Server 10.1.5, and the logfile is
getting quite large because it logs this:
bootstrap_look_up() failed (ipc/send) invalid destination port
about once a minute. I have not changed the configuration file at all
from the defaults. The server seems to be w
On Mon, 8 Jul 2002, Tim Ellis wrote:
> Is there not a method of reading a disk block and instructing the OS not
> to buffer it, or am I hallucinating?
Yes. Read the block from a raw device. Of course, it's up to you to deal
with an filesystem issues or whatever. :-)
FreeBSD also has the O_DIREC
Hello, lists,
I know I've posted about 7 release announcements for tedia2sql, but
features keep getting added! I'll try to keep announcements down to an
every-other-week frequency from now on.
Again, quick tedia2sql summary: Dia UML diagrams converted to SQL DDL for
Postgres, Oracle, DB2, Sybase
Back in the days when I used Oracle, there was something called SQL*Loader
that allowed you to read a flat ASCII file into an Oracle table.
If I were doing this, I think I'd do a pg_dump of the data, filter the dump
file to remove the "copy" commands & then use SQL*Loader or it's newer
equivalent
At 12:41 AM 7/8/02 , Simeone, Mario wrote:
>help
Con che cosa?
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228
---(end of broadcast)---
Uh, not really. pg_passwd is for managing secondary passwords.
---
Felipe Nascimento wrote:
> take a look at.
> http://archives.postgresql.org/pgsql-admin/2001-09/msg00095.php
>
> the utility you are looking for is: pg_p
39 matches
Mail list logo
