Naomi Walker <[EMAIL PROTECTED]> writes:
> Does Postgres have some keen trick to trash log files when you are out of
> space, or did something else save our behinds?
You got lucky ... PG *will* complain loudly when it runs out of disk
space.
regards, tom lane
---
Last night, we upgraded from 7.1.2 to 7.3.4 on our Sun E3500's, running
Solaris 6. Everything went well, except that we appear to have dodged a
bullet, and that mystifies me.
Somehow, nobody noticed that the data filesystem was at 100%, yet this
heavily used application that uses postgres con
Is there a good way to store a query plan using libpq? Can someone
point me a good way, other than using SPI? Thanks!
Kris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ow writes:
> If a *schema* is dumped and then restored on a different server, will it be
> necessary to also restore system schemas, e.g. pg_catalog?
No.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all
On Dec 1, 2003, at 2:34 PM, Christopher Browne wrote:
[EMAIL PROTECTED] (Renney Thomas) writes:
I would like to hear about any issues related to erserver. I was a
little concerned about its use of Java. Java is a great tool for
creating application frameworks for the payroll department, but using
[EMAIL PROTECTED] (Renney Thomas) writes:
> I would like to hear about any issues related to erserver. I was a
> little concerned about its use of Java. Java is a great tool for
> creating application frameworks for the payroll department, but using
> it for back-end system-level application progr
Look in postgresql.conf file:
#
# Message display
#
server_min_messages = info # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log, fatal,
# panic
client_min_messages = info # Values, in order of decreasing det
After a long battle with technology, [EMAIL PROTECTED] (Renney Thomas), an earthling,
wrote:
> Has anyone any experience with PGSQL 7.x and implenting the FTC
> do-not-call list - which is about 50 million 10 digit N. American
> phone numbers? If so what structures have you used and what have you
pgSql 7.4.0
Hi,
If a *schema* is dumped and then restored on a different server, will it be
necessary to also restore system schemas, e.g. pg_catalog?
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-
Hi,
I have the following table:
CREATE TABLE public.rights (id int4 DEFAULT
nextval('"rights_id_seq"'::text) NOT NULL, id_user int4 NOT NULL, id_modull int4 NOT NULL, CONSTRAINT rights_pkey PRIMARY KEY (id))
and I created the following indexes:
CREATE INDEX right_id_modull_idx ON
rights
> problem:- in postgresql there is any command to see history (previous
> day queries) like as history command in linux.
In addition to server and client logging levels adjusted via the
postgresql.config file, psql also has a
command history like bash that is preserved between sessions. The c
On Thu, 4 Dec 2003, Alan Graham wrote:
> I'm doing a low cost, low performance roll your own replication project,
> between various offices around Australia. The replication is
> asynchronous, and peer to peer. I've looked at the various replication
> projects, and for one reason or another, th
On Thu, 4 Dec 2003, Alan Graham wrote:
> I'm doing a low cost, low performance roll your own replication project,
> between various offices around Australia. The replication is
> asynchronous, and peer to peer. I've looked at the various replication
> projects, and for one reason or another, t
I'm doing a low cost, low performance roll your own replication project,
between various offices around Australia. The replication is
asynchronous, and peer to peer. I've looked at the various replication
projects, and for one reason or another, they're too hard.
My design uses jabber as middlew
On Thu, 4 Dec 2003, Andrei Bintintan wrote:
> Hi,
>
> I have the following table:
> CREATE TABLE public.rights (
> id int4 DEFAULT nextval('"rights_id_seq"'::text) NOT NULL,
> id_user int4 NOT NULL,
> id_modull int4 NOT NULL,
> CONSTRAINT rights_pkey PRIMARY KEY (id)
> )
>
> and I created the fol
Ashok Chauhan wrote:
> hi
> there is any utility or command in postgresql for incremental backup or
> incremental restore.
No, but we are working on it.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a
Renney Thomas wrote:
> Has anyone any experience with PGSQL 7.x and implenting the FTC
> do-not-call list - which is about 50 million 10 digit N. American phone
> numbers? If so what structures have you used and what have you done
> interms of performance tweaks? Is there an equivalent to Oracle
On Wed, 4 Dec 2003, Ashok Chauhan wrote:
> i am a new user in postgresql.
> problem:- in postgresql there is any command to see history (previous
> day queries) like as history command in linux.
Not precisely. For the backend, you can log the statements that are run
by changing the postgresql.c
Dear Ashok,
Hope you are not using
Postgresql 7.4
if this is the case I think some insert /update statements are waiting
for commit command
Regards,
V Kashyap
hi
i am a new user in postgresql.
problem:- in postgresql there is any command to see history (previous
day queries) like as history com
Look in postgresql.conf file:
#
# Message display
#
server_min_messages = info # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log, fatal,
# panic
client_min_messages = info # Values, in order of decreasing det
On Thu, 4 Dec 2003, Sai Hertz And Control Systems wrote:
>
> Dear Ashok,
>
> Hope you are not using
> Postgresql 7.4
> if this is the case I think some insert /update statements are waiting
> for commit command
>
> Regards,
> V Kashyap
>
> >hi
> >i am a new user in postgresql.
> >problem:- in p
Dear Ashok ,
hi
i am a new user in postgresql.
If you are from Kalculate team which
developed first Financial software in India with QT and PostgreSQL as
back end then
for me this is a prank that a member of Kalculate team addresses
himself to be new to PostgreSQL.
Chauhan saab give us s
hi
i am a new user in postgresql.
problem:- in postgresql there is any command to see history (previous
day queries) like as history command in linux.
thank you
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister c
23 matches
Mail list logo
