Title: Database Recovery
I need help restoring a postgres database. My postgres server was destroyed by a tornado, but the raid drives containing the data are still intact. I built a new machine and mounted the raid drives, but I can't get the new installation of postgres to load the old da
Hi,
In ORACLE I can perform the following query:
SELECT tableA.id, title, qty
FROM tableA, (SELECT id, count(*) qty FROM tableB group by id) tableC
WHERE tableA.id = tableC.id (+)
but in PostgreSQL I get error message.
How can I perform it in Postgres?
thanks,
robert
Hi,
During the last few weeks I get the following err message quite often. What
does it mean and how can I fix it? I'm running 6.3.2 on BSDI 4.1
ERROR: cannot write block 1 of maxid [tnt2] blind
\Magnus
--
they i do it those infrequent times i need to is using a
program called dbf2sql that will convert from dbf.
At 02:22 PM 4/10/00 +, Steve Murphy wrote:
>Hi,
>
>Does anyone know of any conversion programs that will either convert an
>MS Access database file to a Postresql database or from a
Vipin Samtani wrote:
>
> hi,
> i am a novice user running Red Hat Linux Server 6.
> what files do i need to download to install PostGreSQL?
> vipin
ftp://ftp.postgreSQL.org/pub/postgresql-7.0beta5.tar.gz
(it's beta, but it's best)
Also, no need to blast all the lists with the question. pgsql
On Sun, Apr 09, 2000 at 11:43:35PM -0400, Vipin Samtani wrote:
-> hi,
-> i am a novice user running Red Hat Linux Server 6.
-> what files do i need to download to install PostGreSQL?
-> vipin
->
Have you checked to see if there is an RPM package on your RH CD?
--
-- C^2
No
Hi,
Does anyone know of any conversion programs that will either convert an
MS Access database file to a Postresql database or from a Filemaker Pro
database file to a Postresql database for the Red Hat Linux OS?
Any help or educated guesses of where to start looking would be
extremely welcome.
[EMAIL PROTECTED] wrote:
>Also I'd like to know if simple foreign keys are implemented in PostgreSQL
>6.5.3?
use refint from contrib/spi
It isn't as flexible and convenient as the RI that's built into 7.0, but it
will do most of the job.
--
Oliver Elphick[E
