On Thu, Feb 16, 2006 at 09:11:13PM -0800, Gregory S. Williamson wrote:
> See that double space after "Media" ? That's actually a single space, a dash,
> and another space: "XYZ Media - AB&E", but every export turns it into:
> XYZ Media <96> AB&E
I'm not sure if I got your problem correctl
"Gregory S. Williamson" <[EMAIL PROTECTED]> writes:
> I am trying to migrate a modest sized database (the unload file is just under
> a gigabyte) which is moderately complex, using schemas and the like from 7.4
> to 8.1
> Alas, pg_dump appears to incompatable with my needs as it keeps introducing
I am trying to migrate a modest sized database (the unload file is just under a
gigabyte) which is moderately complex, using schemas and the like from 7.4 to
8.1
Alas, pg_dump appears to incompatable with my needs as it keeps introducing
invalid UTF-8 characters.
I have gone back and changed
On 2/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> SuSE always only do backports of fixes and never increase the version
> number. They only appended a self made "build" number which increases.
> So it is really possible that all the fixes are in while the version
> stays the same.
Not tr
On Thu, 2006-02-16 at 10:39, Tomeh, Husam wrote:
> I do understand your school of thinking. But let me say this, from just
> a user point of view who had used 7.4.x, 8.0, and 8.1, I'd highly
> recommend to start off with 8.1. I can comment on performance in
> particular among other great stuff suc
Thanks. I wasn't sure that I should do that since I didn't change
those permissions since I hadn't done anything with it. There is a
new user who is taking over admin of this machine, so I'll have to
ask if the did anything to affect this.
Barry
On Feb 16, 2006, at 11:30 AM, Jeff Frost w
Hi,
maybe a bit late but how about DRBD (http://www.drbd.org)?
BTW: Very nice that this feature is on the TODO :-))
Cheers,
Robert
Simon Riggs wrote:
On Sun, 2006-02-12 at 11:47 +0100, [EMAIL PROTECTED] wrote:
How Can I do that ?
This is on my todo list for 8.2, but not yet at the
On Thu, 16 Feb 2006, Barry Moore wrote:
So with my minimal system admin skills I'm guessing that '/tmp/.s.PGSQL.5432'
is lock file where the system puts a lock on port 5432 for postmaster to
listen, but the pg_ctl and postmaster commands can't create that file because
/tmp is writeable only by
I have a PostgreSQL 7.4.8 installation running on RedHat Enterprise 4
that I've been using for some time now, and haven't had any trouble
with. Recently the system went down, and now I can't seem to restart
it. I've tried running these commands as postgres user:
nohup postmaster -D /var/l
On Wed, Feb 15, 2006 at 09:00:41PM -0500, Tom Lane wrote:
> David Bear <[EMAIL PROTECTED]> writes:
> > now, back on teancum that has the tunnel on port , I do this:
>
> > [EMAIL PROTECTED]:~> psql -p -h localhost -U tlhowell
> > psql: FATAL: Ident authentication failed for user "tlhowell
Tom Lane <[EMAIL PROTECTED]> writes:
> Jerry Sievers <[EMAIL PROTECTED]> writes:
> > Any of these connections that may have previously executed PL
> > functions which planned an index lookup are now going to fault if same
> > index goes away.
>
> > Had wondered if a postmaster 'reload' would elic
I do understand your school of thinking. But let me say this, from just
a user point of view who had used 7.4.x, 8.0, and 8.1, I'd highly
recommend to start off with 8.1. I can comment on performance in
particular among other great stuff such as scalability, robustness etc.
The performance in 8.1
Jerry Sievers <[EMAIL PROTECTED]> writes:
> Any of these connections that may have previously executed PL
> functions which planned an index lookup are now going to fault if same
> index goes away.
> Had wondered if a postmaster 'reload' would elicit a recompiling of
> func query plans (did *not*
Hello.
I am curious what (if any) reliable solution/workaround there is in
cases where objects that are a part of a currently cached query plan
disappear unexpectedly.
Using JDBC and pooled connections, our production system has at any
time 120 or so live connections, most in an idle state. They
14 matches
Mail list logo
