Why not just export as 'insert into (... ) values (...)' format. If
ingres can't export as such, you can write a select statement to do this.
Slow, sure - but the lowest common denominator.
Steve
On Wed, 10 Sep 2008 11:27:58 -0400
"Markova, Nina" <[EMAIL PROTECTED]> wrote:
>
> I also plan
t you want in a simple, repeatable manner.
If it's mysql 5 then the stored procedures may need to be converted - I know
there are tools out there, but haven't used them and can't comment.
Steve
--
Steve Holdoway <[EMAIL PROTECTED]>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
,type="win32",version="8.0.50727.762"
> C:\Program Files\PostgreSQL\8.3\bin\initdb.exe
>
>
>
> I couldn't figure out what I was supposed to do with sxstrace.exe,
> though. The usage example showed parsing a *.etl file, but I can't find
> any of these on my system.
>
> Any help would be appreciated.
>
> Thanks,
>
> Brandon
>
--
Steve Holdoway <[EMAIL PROTECTED]>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
or ownership
>
>
> Thanks
>
> Steve
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
Add that user to the postgres group?
--
Steve Holdoway <[EMAIL PRO
while [ ! -d /qmsvol/pg_8.1.9/data ]
do
sleep 5
done
( well, something that can't hang forever would be preferable! ).
>
> Thanks
> Medi
>
hth,
Steve
--
Steve Holdoway <[EMAIL PROTECTED]>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Fri, 18 Apr 2008 00:21:23 +0400
David Jorjoliani <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have daily cron jobs for database update, which where working fine on
> Fedore Core 6. No I move it on Ubuntu Server 7.10 and postgres gives error:
>
> "unexpected EOF on client connection"
>
> while upda
to set up your PATH and HOME manually, and cd to your home directory
before sourcing .bashrc for this to work.
. ~/.bashrc *might* work, but it's better to be specific (:
hth,
Steve
--
Steve Holdoway <[EMAIL PROTECTED]>
---(end of broadcast)---
On Wed, 27 Feb 2008 13:48:38 +1100
"Phillip Smith" <[EMAIL PROTECTED]> wrote:
> > Coming in the middle of this thread, so slap me if I'm off base here.
> > tar will accept standard in as:
> >
> > tar -cf -
> >
> > the '-f -' says take input.
>
> That would be to write to stdout :) I can't figu
On Mon, 25 Feb 2008 18:21:19 -0700
David Bear <[EMAIL PROTECTED]> wrote:
> I've been reading about triggers on insert and found the page at
> http://www.postgresql.org/docs/8.1/interactive/triggers.html with some sample
> code in the comments.
>
> I'm thinking what I want can't really be this i
On Wed, 20 Feb 2008 12:22:45 -0800
Darren Reed <[EMAIL PROTECTED]> wrote:
> # dd if=/dev/zero bs=8192 count=1 | cat >> 0004
dd if=/dev/zero bs=8192 count=1 >> 0004
saves loads of electrons (:
pgpadvsqYcW3k.pgp
Description: PGP signature
On Wed, 16 Jan 2008 10:19:12 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Steve Holdoway <[EMAIL PROTECTED]> writes:
> > You can be absolutely certain that the tar backup of a file that's changed
> > is a complete waste of time. Because it changed while you we
a D. Drake
> > >
> > > > Thanks
> > > >
> > > > --
> > > > Brian Modra Land line: +27 23 5411 462
> > > > Mobile: +27 79 183 8059
> > > > 6 Jan Louw Str, Prin
On Tue, 13 Nov 2007 21:00:02 +0100
Laszlo Nagy <[EMAIL PROTECTED]> wrote:
[snip]
What are postgres's ulimits???
pgp78JRZdFQzS.pgp
Description: PGP signature
On Mon, 13 Aug 2007 13:07:43 -0500
"Kevin Grittner" <[EMAIL PROTECTED]> wrote:
> >>> On Mon, Aug 13, 2007 at 12:50 PM, in message <[EMAIL PROTECTED]>,
> olivier boissard <[EMAIL PROTECTED]> wrote:
> > I tried to use the except command in postgresql 8.1
> > I don't understand as it works
> > When
On Wed, 25 Jul 2007 12:38:31 +
"Vishal Arora" <[EMAIL PROTECTED]> wrote:
>
>
>
> >From: "Milen A. Radev" <[EMAIL PROTECTED]>
> >To: pgsql-admin@postgresql.org
> >Subject: Re: [ADMIN] Using Explain
> >Date: Wed, 25 Jul 2007 14:26:57 +0300
> >
> >Vishal Arora напиÑа:
> > >
> > > Hi All,
Could I just suggest that you upgrade to 10.2? 10.1, especially the 64 bit
version, is a bit rough in places.
Steve.
On Thu, 19 Jul 2007 01:27:26 -0700 (PDT)
nilesh khode <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have installed Postgresql 8.2.4 using Tarball on Suse Linux 10.1 (64 Bit).
>
> I
Sounds like a Bad Idea(tm) to me. If you want to create extra systemmy tables,
then why not set up your own private resources, and put them there instead???
Steve
On Mon, 9 Jul 2007 11:22:05 +0200 (CEST)
Carmen Martinez <[EMAIL PROTECTED]> wrote:
> I want to insert new tables in the pg_catalog
6 May 2007 11:08:10 +1200
Steve Holdoway <[EMAIL PROTECTED]> wrote:
> Can anyone out there help me, I'm having a bit of a problem trying to improve
> the performance of a php script that does a data load?
>
> At the moment, the script checks a database to see if the entry is
Can anyone out there help me, I'm having a bit of a problem trying to improve
the performance of a php script that does a data load?
At the moment, the script checks a database to see if the entry is present,
and, if not, it adds it. The table has about 400,000 rows, and I'm checking a
bulk loa
atch many of these gotchas before going live. Also, you might want to
> create test versions of your apps and try them against the 8.2 server.
>
> On the whole, I've found postgres to be very good at maintaining backwards
> compatibility of interfaces and sql, so I estimate
Thanks, I knew about that one, and spent half a day cleaning up the data set
before transfer.
That was exciting...
Cheers, Steve
On Thu, 10 May 2007 08:57:25 -0600
Dan Harris <[EMAIL PROTECTED]> wrote:
> Steve Holdoway wrote:
> > Are there any gotchas? I've got the op
Are there any gotchas? I've got the opportunity to move to another database
server for this application and yould like to take the opportunity to upgrade
at the same time.
tia,
Steve
---(end of broadcast)---
TIP 7: You can help support the Postgr
I'm in the enviable position of migrating postgres database from the current
machine to a dedicated server platform. I would also like to take the
opportunity to upgrade the version of postgres to current. Does anyone know of
any gotchas in this process that I should be especially looking out f
On Thu, 1 Feb 2007 23:04:57 -0500
"Chad Wagner" <[EMAIL PROTECTED]> wrote:
> I have plenty of experience building large distributed OLTP systems and
> multi terabyte data warehouses, so you can either take the advice or leave
> it.
>
Me too, since Oracle 6, Informix and Ingres in the late 80's un
On Wed, 31 Jan 2007 18:45:15 -0500
"Chad Wagner" <[EMAIL PROTECTED]> wrote:
> On 1/31/07, Steve Holdoway <[EMAIL PROTECTED]> wrote:
> >
> > The table I'm concerned with at the moment have (currently) 5 million
> > rows, with a churn of about 300,00
bit.
>
> My 2.2 cents (Aust. GST inclusive!)
>
> Cheers,
> -p
>
> -Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Steve Holdoway
> Sent: Thursday, 1 February 2007 08:46
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] b
I'm got the enviable task of redesigning an MySQL based project from scratch.
We need a proper rdbms for this project, and I want to use PG 8.2.
The table I'm concerned with at the moment have (currently) 5 million rows,
with a churn of about 300,000 rows a week. The table has about a million hi
On Thu, 30 Nov 2006 18:12:31 +0200
"Milen A. Radev" <[EMAIL PROTECTED]> wrote:
> We have a big DB that's backuped nightly using pg_dump in the custom
> format. Most of its size are several thousand large objects. During
> the dump of those LO the machine is heavily loaded so we are looking
> for a
I'm trying to write a pl/pgsql trigger to validate incoming data to an existing
database. One of the fields is defined as character varying (255). Is there any
way of catching over-length data on inserts and silently dropping them? At the
moment, I'm getting the error 'ERROR: value too long for
29 matches
Mail list logo
