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
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
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
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's
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
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
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,
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,
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
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
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/
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
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
[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
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
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 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 following
17 matches
Mail list logo