Hi, actually what I was after was a continuous way to keep a
PostgreSQL db in sync with a changing MSSQL db. Migrating
data from MSSQL to PostgreSQL is pretty easy. The method
you described is one way. The way we usually use is with
PgAdmin (a great tool) which has a Migration Wizard plugin
to a
On Thu, Nov 14, 2002 at 10:47:20AM +0300, dima wrote:
> 2) think about writing a server which would provide cgi scripts with
> cached connections; you can $handle->prepare(...) the most common
> queries as well.
This seems like a common requirement. Are there any such tools which
can be run in
Chris Miles wrote:
On Thu, Nov 14, 2002 at 10:47:20AM +0300, dima wrote:
2) think about writing a server which would provide cgi scripts with
cached connections; you can $handle->prepare(...) the most common
queries as well.
This seems like a common requirement. Are there any such tools whic
Frankly, I cannot remember. It was before the election that I did it and
it has been a very busy few weeks since then. I bookmarked several pg
pages in my browsers and suspect that I downloaded and compiled it on my
own, instead of using the apt-get utility. Please do send me that
script. T
I am trying to set up my cron job to run the
appropriate vacuums on our database. I understand from reading the documentation
that regular vacuums, vacuum full, and vacuum analyze are all important. Can
someone assist in telling me what is the most efficient order? I would assume
that analyz
Honestly this is very dependent on the type of schema you have and what
your application does with it. If you have tables that get a lot of
updates (or both inserts and deletes) you will want to run vacuum
analyze on those tables more often. How often is debatable, but as a
rule of thumb it good to
This is a known issue that the list maintainers are currently working
on, but no eta right now on when it will be fixed :-(
Robert Treat
On Thu, 2002-11-14 at 08:14, Gaetano Mendola wrote:
> Hi all is almost one week that I'm not able to
> retrieve message from the NG : unable to connect
> Hi, actually what I was after was a continuous way to keep a
> PostgreSQL db in sync with a changing MSSQL db.
> Once the data is migrated, a method of syncing any updates
> in the MSSQL db to the PostgreSQL db is what we require.
> I haven't discovered a nice way of doing that yet.
I've setup
Robert Treat <[EMAIL PROTECTED]> writes:
> ... As for vacuum
> full, with frequently enough "lazy" vacuuming you wont need to vacuum
> full very often. If you can afford to lock your tables, then I'd say do
> it once a night. If not, you need to decide when is a good time, but I
> think the docs re
On Thu, 2002-11-14 at 17:18, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
>
> (Right now the only way to set up an appropriate vacuuming schedule is
> for the DBA to hand-craft a cron script. I'd like to see the database
> able to launch automatic background vacuum runs by itself.)
We installed Postgres on a Redhat system using rpm.
The default directory is /var/...
We would to change to /usr/mybases without destroying existing bases.
How to do?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.408 / Virus Da
On Fri, 8 Nov 2002, Nick Fankhauser wrote:
> AM-
>
> The band-aid patch is to increase the number of connections available. Check
> out this link to the idocs:
>
> http://www.postgresql.org/idocs/index.php?runtime-config.html
>
> Maybe that will keep things running for you while you go over the
While using 7.1.2 I get the following error, any idea what this
is?
FATAL 2: MoveOfflineLogs: cannot read xlog dir: No such file or directory
Server process (pid 14656) exited with status 512 at Wed Nov 13 14:07:17
2002
Terminating any active server processes...
Server processes were t
Hi all is almost one week that I'm not able to
retrieve message from the NG : unable to connect
--
Ciao
Gaetano
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
LDC - Pablo Endres Lozada <[EMAIL PROTECTED]> writes:
> While using 7.1.2 I get the following error, any idea what this
> is?
> FATAL 2: MoveOfflineLogs: cannot read xlog dir: No such file or directory
Something wrong with the permissions on $PGDATA/pg_xlog, perhaps?
I'm operating in Debian Woody, with postgreSQL 7.2. -- Hugh
At 04:19 PM 11/13/02 -0500, you wrote:
on linux 7.2, I just type "ntsyv" and check the postgres daemon to start
automatically. Don't know about other systems.
Hugh Esco wrote:
Hello:
Although /etc/init.d/postgresql script is listed in
> I'm operating in Debian Woody, with PostgreSQL 7.2. -- Hugh
Hugh-
Did you install from the Debian package or compile-your-own? We're running
7.2 on Debian 2.4, and the startup/shutdown script that Oliver Elphick
created for the Debian package has worked flawlessly for us.
If you did your own
What you're looking for is SQLRelay. You will need to work a little bit
around the DBI driver to get the cached connections, but since the
driver uses its native interface, this is possible (or you can scrap
DBI altogether- not recommended). Get it here:
http://taonix.org/
because firstworks.com
Unfortunately Apache::DBI handles per-process connections only. So,
almost any httpd child will hold all the connections. If you use user
sessions as well, you'll run even into more serious troubles.
What you're looking for is SQLRelay. You will need to work a little bit
around the DBI driver t
Hi all is almost one week that I'm not able to
retrieve message from the NG : unable to connect
--
Ciao
Gaetano
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAI
got it all back up tonight ...
On Thu, 14 Nov 2002, Gaetano Mendola wrote:
> Hi all is almost one week that I'm not able to
> retrieve message from the NG : unable to connect
>
>
>
> --
> Ciao
> Gaetano
>
>
>
>
>
> ---(end of broadcast)---
> TI
21 matches
Mail list logo
