[EMAIL PROTECTED] wrote:
PostgreSQL runs for a while but always eventually (30min - 2hrs) crashes.
I thought it was memory initially but Memtest had no errors after running
for a day. I don't think it is a hardware issues because I can run other
applications without error. I have ran both vers
- Original Message -
From: "sandhya" <[EMAIL PROTECTED]>
To: "Michael Fuhr" <[EMAIL PROTECTED]>
Sent: Thursday, December 22, 2005 1:15 PM
Subject: Re: [ADMIN] How to get OID return value(pls help me)
> What function is that? What does it do with the oid?
>
> It is normal C function ...
I want to be able to do large updates on an existing backed up database
with fsync=off but at the end of the updates how do I ensure that the
data gets synced?
Somebody said running "sync ; sync; sync" from the console. This seems
reasonable but why not just "sync" or is there another command
Hi,
Have a major reliability problem with out postgres installation here.
Basically the backends seem to "hang" when the server is under
non-trivial load. It can cope with ~200 concurrent connections (max is
1024) but anything over that and all the backends start to hang. By hang
I mean they answe
On Thu, Dec 22, 2005 at 11:05:22AM +0530, sandhya wrote:
> My table consists of oid and varchar datatypes.
> I want to get the oid type from the table and i need to pass it to
> a function which accepts only the oid data type.
What function is that? What does it do with the oid?
> But my problem
Hi..
My table consists of oid and
varchar datatypes.
I want to get the oid type from the
table and i need to pass it to a function which
accepts only the oid data type.
But my problem is the
return value of the datatype i am getting from the
query result is char*.
Is there any funct
Unsucbribe PGADMINnhan__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
[EMAIL PROTECTED] wrote:
> Which version of pg_dump did you use to dump the old database? The
> recommended procedure is to use the newer version of pg_dump (ie:
> pg_dump from 8.1.1) to dump the old database. It's possible that the
> newer version of pg_dump has facilities in place to deal with th
What do you mean with this???
binary data in XML needs to be uuencoded afaik,
On 12/19/05, Jim Nasby <[EMAIL PROTECTED]> wrote:
Including -admin back in the discussion...Well, binary data in XML needs to be uuencoded afaik, and of course you'll want to put it in a CDATA block.
PostgreSQL doe
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> "ALTER USER is now an alias for ALTER ROLE, which see for more
> information."
> Someone want to commit a quick grammar fix to that? Maybe "which you
> should see for more..."?
It's perfectly good English as-is.
regards, tom la
On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:
> All the documentation I've seen for PITR points to having to do a file
> system copy of sorts.
Yes. There's no other way, but why would you want another way?
> Is it possible to have a weekly pg_dump and restore the database up to
> the last arc
On Thu, 2005-12-15 at 14:40 -0600, Jim C. Nasby wrote:
> I haven't played with PITR, but I believe that if PostgreSQL doesn't get
> the right return code from the archive_command it will keep the WAL
> files around; maybe that's the problem.
>
> On Wed, Dec 14, 2005 at 10:57:38AM +0100, [EMAIL PRO
<[EMAIL PROTECTED]> wrote
>
> PostgreSQL runs for a while but always eventually (30min - 2hrs) crashes.
> I thought it was memory initially but Memtest had no errors after running
> for a day. I don't think it is a hardware issues because I can run other
> applications without error. I have ran
On Wed, Dec 21, 2005 at 04:35:00PM -, Donald Fraser wrote:
> Roles are a great improvement to postgresql, but we also talking security
> issues here:
> Our module controls things like:
> 1) how long before a user must change their password (daily, weekly, monthly
> etc)
> 2) password rotation -
On Wed, Dec 21, 2005 at 04:15:35PM -, Donald Fraser wrote:
> Our "user" table holds security privilege and access rights
> information which can change at the drop of a hat. Our approach to
> managing the mapping of our privileges to PostgreSQL GROUPS
> etc has been one of brute force. It is mu
On Wed, Dec 21, 2005 at 02:11:18PM -0600, Scott Marlowe wrote:
> On Wed, 2005-12-21 at 14:02, Jim C. Nasby wrote:
> > On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> > > Is the server running locally and accepting connections on Unix domain
> > > socket "/tmp/.s.PGSQL.5432"?
> >
> >
Which version of pg_dump did you use to dump the old database? The
recommended procedure is to use the newer version of pg_dump (ie:
pg_dump from 8.1.1) to dump the old database. It's possible that the
newer version of pg_dump has facilities in place to deal with this.
Those facilities would obviou
PostgreSQL runs for a while but always eventually (30min - 2hrs) crashes.
I thought it was memory initially but Memtest had no errors after running
for a day. I don't think it is a hardware issues because I can run other
applications without error. I have ran both version 8.0.3 and 8.1.1 with
th
On Wed, 2005-12-21 at 14:02, Jim C. Nasby wrote:
> On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> > Is the server running locally and accepting connections on Unix domain
> > socket "/tmp/.s.PGSQL.5432"?
>
> So what are the permissions on /tmp/.s.PGSQL.5432? Can apache write to
> i
On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> Is the server running locally and accepting connections on Unix domain
> socket "/tmp/.s.PGSQL.5432"?
So what are the permissions on /tmp/.s.PGSQL.5432? Can apache write to
it?
Actually, I think apache normally chroot's to ServerRoot
> Given the stack traces, I no longer think it's a data corruption issue
> --- somehow libc is screwing up. Backends are single-threaded and there
> is *no* reason for pthread_mutex_lock to block, ever.
>
> I have a vague recollection that we saw something similar reported once
> before, but it w
> ERROR: cache lookup failed for type 12345
>
> I thing that maybe there is(are) parameter(s) that need to be configure to
> give more cache to prevent this error
>
> can you help me ?
>
this is not about memory... it's a bug... can you provide info about
the version that you have?
--
regards,
Ja
- Original Message -
From: "Alvaro Herrera"
> Donald Fraser wrote:
>
> > We developed and have been using since 7.1, and currently running 7.4,
> > bespoke client / database software. The ability to manage users and
security
> > was of high priority and we therefore developed a much more
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> From: "Tom Lane"
>> keeping the currently assigned OID in the aux table, setting the
>> field to null or zero if the user doesn't currently exist in pg_authid.
> Our "user" table stores information about the user before, during and
> after the user is
- Original Message -
From: "Tom Lane"
> It's not apparent to me why you have to control the userID in order to
> have an auxiliary table defining a user. You could do something like
When ever a postgresql user does anything to a record in a table we
have a trigger function to check at
Ulrich Wisser <[EMAIL PROTECTED]> writes:
> after Tom's last hint I checked the locale of my installation. With a
> test installation with locale C all my problem scripts worked. Now I
> wonder what will happen if I dump my whole database, reinitialize with
> locale C and reload my data. Will th
Jonathan Parkin <[EMAIL PROTECTED]> writes:
> On Tue, 2005-12-20 at 16:37, Tom Lane wrote:
>> If this is a specific row causing the issue, then I'd wonder about
>> data corruption of some sort. It might be worth looking at the
>> table with pg_filedump (from http://sources.redhat.com/rhdb/).
> Ou
Hi all,
according to the documentation I tried to open a new connection
selecting the entry in the toolbar combobox in a single
Query Tool instance.
But no dialogbox appears. If I select and run the query
it's run on the instance I'm already connected to.
Does someone know how to establish a ne
Hi,
I dont´t know if i understand exactly your problem, but ...
When i tried to delete all of the rows of a table , it seems to never end.
So i created an index to each foreing key and the command works very fast.
Good Luck!
Andréa Pereira
Brasil-Recife
- Original Message -
From: "Jonatha
Hello,
after Tom's last hint I checked the locale of my installation. With a
test installation with locale C all my problem scripts worked. Now I
wonder what will happen if I dump my whole database, reinitialize with
locale C and reload my data. Will this have some impact on my character
data
On Tue, 2005-12-20 at 16:37, Tom Lane wrote:
> Jonathan Parkin <[EMAIL PROTECTED]> writes:
> > I have a reasonably large, live, system-critical database. A perl
> > script on another machine connects and issues a sequence of commands in
> > a transaction, the last of which is a delete. The delete
There are no conflicting locks; this occurs both concurrently with other
processes (dealing with other rows) and when the only two processes with
locks on the database are the one that hangs and the one I'm using to
examine pg_locks.
On Wed, 2005-12-21 at 08:02, Pandurangan R S wrote:
> When the d
Armel HERVE wrote:
Magnus Hagander wrote:
we made some custom types (written in C) for PostgreSQL onto
a Linux server.
We need to deploy a Windows server...
The documentation does not talk about a shared library for Windows
(http://www.postgresql.org/docs/8.1/interactive
Magnus Hagander wrote:
we made some custom types (written in C) for PostgreSQL onto
a Linux server.
We need to deploy a Windows server...
The documentation does not talk about a shared library for Windows
(http://www.postgresql.org/docs/8.1/interactive/xfunc-c.html#DFUNC)
I tried to
When the delete statements hangs, look into the pg_locks table, to
check if the delete statement is waiting because it has conflict with
rows locked by other transactions.
On 20 Dec 2005 16:21:53 +, Jonathan Parkin
<[EMAIL PROTECTED]> wrote:
> I have a reasonably large, live, system-critical d
35 matches
Mail list logo
