Hi,
Please explain me is there any difference if i
load my files(like gif or any images files) into the data base as text
format?
Bcoz,I have loaded my image files in a text format into the
database and when i exported it into my local file system the content of the
original file(i.e. imp
"Paul J. & Melinda Savoy" <[EMAIL PROTECTED]> writes:
> I get the following error:
> ERROR: schema "dvccntl" does not exist
> I created each schema (8) in all and they all exist.
Right offhand I bet you're getting bit by case-folding rules.
"DVCCNTL" and "dvccntl" aren't the same, and unquote
I just downloaded postgres 8.1 and in trying to run the sql script below
I get the following error:
ERROR: schema "dvccntl" does not exist
I created each schema (8) in all and they all exist. I've looked at the
documentation the way I have this written looks correct but I'm unsure
why a
Hi Chris,
I'm pretty sure (I do no timing on the Hibernate/java/app side). I changed the
config to:
# log queries that take more than 1 ms
log_min_duration_statement = 1 # in ms
Still nothing in the log :) (I did ctl_reload the postmaster)
Simon Riggs confirmed this is a known bug in a
sweet! Thanks for the great info. We have been planning to upgrade
when we find a good window.
Thank you!
-Kenji
On Wed, May 10, 2006 at 01:57:24PM -0600, Michael Fuhr wrote:
> On Wed, May 10, 2006 at 12:06:46PM -0700, Kenji Morishige wrote:
> > Is there any way from PostgreSQL user authenticati
[EMAIL PROTECTED] writes:
> Hi,
>
> I'm running PG 8.0.3. I'm trying to catch slow queries, so I have this in
> postgresql.conf:
>
> # log queries that take more than 500 ms
> log_min_duration_statement = 500 # in ms
>
> This does log _some_ queries that take > 500 ms to run.
> However,
mcelroy, tim wrote:
Thanks Scott, great idea. Does one use pg_restore to restore the files
that pg_dumpall creates?
No, oddly you use psql.
Sincerely,
Joshua D. Drake
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 3:35 PM
To:
On Wed, May 10, 2006 at 12:06:46PM -0700, Kenji Morishige wrote:
> Is there any way from PostgreSQL user authentication or other
> methods to cap connection count by user or by host?
What version are you running? 8.1 has per-user and per-database
connection limits; search for CONNECTION LIMIT in
Title: RE: [ADMIN] backups
Thanks Scott, great idea. Does one use pg_restore to restore the files that pg_dumpall creates?
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2006 3:35 PM
To: mcelroy, tim
Cc: 'Bruno Wolff III'; '
rpm -qa | grep postgresql
postgresql-7.4.9-alt1.1
postgresql-server-7.4.9-alt1.1
#
tcpip_socket = true
max_connections = 512# note: increasing max_connections costs about 500 bytes
of shared
# memory per connection slot, in addition to costs from shared_buffers
# and max_locks_per_transacti
We are having a problem where we are running out of connections due to a
in-house tool that creates abnormal amount of connections due to fluctuating
loads that we cannot control. Ideally, the tool could be re-written to take
into account for those situations, but due to its complexity we don't
On Wed, 2006-05-10 at 14:11, mcelroy, tim wrote:
> Excellent point Bruno, thanks. I must admit that I did think of that
> and have already copied all my .conf files to the backup directory. I
> should have noted that earlier.
>
> Thanks,
> Tim
Another thing to check is that your global data (i.
Title: RE: backups
Excellent point Bruno, thanks. I must admit that I did think of that and have already copied all my .conf files to the backup directory. I should have noted that earlier.
Thanks,
Tim
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]]
Sent:
On Wed, May 10, 2006 at 11:56:20 -0400,
"mcelroy, tim" <[EMAIL PROTECTED]> wrote:
> Thanks for the quick answer Scott. I thought so but wanted to double-check.
> I was asked by the person who performs our system backups if just backing up
> the directory where I put the nightly backups (created
On Wed, 2006-05-10 at 09:34 -0700, [EMAIL PROTECTED] wrote:
> Has anyone seen this behaviour before?
> Are there logging fixes in PG 8.1.3 that might address this issue?
Yes and Yes.
But good detective work.
Sounds like it needs adding to the 8.0 docs...or would you like to put a
comment on the
Title: RE: [ADMIN] backups
Great, exactly the answer I was looking for. Thank you again Scott.
Tim
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2006 12:12 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject:
Hi,
I'm running PG 8.0.3. I'm trying to catch slow queries, so I have this in
postgresql.conf:
# log queries that take more than 500 ms
log_min_duration_statement = 500 # in ms
This does log _some_ queries that take > 500 ms to run.
However, it looks like not all queries get logged!
On Wed, 2006-05-10 at 10:56, mcelroy, tim wrote:
> Thanks for the quick answer Scott. I thought so but wanted to
> double-check. I was asked by the person who performs our system
> backups if just backing up the directory where I put the nightly
> backups (created with pg_dump) was enough. I als
Title: RE: [ADMIN] backups
Thanks for the quick answer Scott. I thought so but wanted to double-check. I was asked by the person who performs our system backups if just backing up the directory where I put the nightly backups (created with pg_dump) was enough. I also have them backing up /v
On Wed, 2006-05-10 at 10:49, mcelroy, tim wrote:
> Greetings,
>
>
>
> Does the pg_dump command ‘backup’ the pg_xlog files?
No. Those are internal files used by the database to maintain
transactional integrity. The pg_dump command backs up the database as
snapshotted at a specific point of ti
Title: dbsize & pg_dump
Greetings,
Does the
pg_dump command ‘backup’ the pg_xlog files?
Thank you,
Tim
Which parameters are critical for the activity of a server postgres?
Which of these parameter (system parameter or postgres parameter) i must
keep monitored to mantain postgres alive and fast?
For example in mysql is important, no. of concurrent connection, no. of
open files, table_cache, connec
Zitat von Ganesh Chaudhari <[EMAIL PROTECTED]>:
Hi,
I am looking for postgresql-8.1.3 rpms for Suse9 and other Suse versions.
Could anybody point me to proper links.
Thanks
Ganesh
Have a look at ftp://ftp.suse.com/pub/projects/postgresql
There are unofficial RPM builds for the supported Su
Am Mittwoch, 10. Mai 2006 12:03 schrieb Ganesh Chaudhari:
> I am looking for postgresql-8.1.3 rpms for Suse9 and other Suse versions.
> Could anybody point me to proper links.
ftp://ftp.suse.com/pub/projects/postgresql/postgresql-8.1.3
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Hi,
I am looking for postgresql-8.1.3 rpms for Suse9 and other Suse versions. Could anybody point me to proper links.
Thanks
Ganesh
Hi,
My Task is to update our SuSE8.2 Postgres7.4.1 Webserver with tsearch2 to
the Version SuSE9.3 with Postgres8.1.3 and tsearch2.
The Services are running but i have some Problems with the
tsearch2
Configuration.
-
"idle in transaction" usually means the software using the database has a bug.
Technically it means your software issues a "BEGIN" statement, but never a
rollback or commit.
PostgreSQL doesn't provide a way to kill processes that are blocked due to
programming errors, that would kind of defeat
unsubscribe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Chris,
In a shell script, you could do a “ps
auxwww|grep ‘idle in transaction’” which would give you a
list of all processes with a status of “idle in transaction.” Then
run through each line of the output, use “awk” to find the process
id, and issue a “kill ” to each process.
Obvi
You could copy the database cluster for
sure, but you wouldn’t be able to read/write any data to it without
PostgreSQL being installed.
If you’re talking about a machine
accessing a database on a different PostgreSQL server, you need the ODBC
drivers (for Windows) or client libraries (L
The easiest way would be to download the
MSI package (on Windows) or the binaries for your flavour of Linux. It
only takes a few minutes to get up and running.
Best thing would be to read through the latest
(v8.1) manual, there’s an installation section in there.
Andy
F
31 matches
Mail list logo
