[GENERAL] Crashed DB and "base" WAL files

Hello, My DB crashed without any recent backup. I only have old DB files. How can i use WAL files and restore_command to restore ? Thanks Franck R.

[GENERAL] Crashed DB and "base" folder files

Hello, My DB crashed without any recent backup. I have old DB files. Can i use "base" folder files to restore ? Thanks Franck R.

[GENERAL] How to restore my database ?

error ? thanks Best regards Cordialement, Franck R. - Axcenteo __ Franck Roubieu [EMAIL PROTECTED] tel :08 74 59 20 20 (tarif d'un appel local) port : 06 12 58 80 62 - AXCENTEO

Re: [GENERAL] How to cluster Postgresql

e, to avoid asking the script to do the work twice. After installation was done, i had a heavy load average on the slave machine. (Heavier than on the master). Franck On Fri, 2005-10-21 at 09:54 -0500, Scott Marlowe wrote: > On Fri, 2005-10-21 at 11:01, Franck Coppola wrote

[GENERAL] How to cluster Postgresql

be interested too : i don't feel very confident with slony). Are there any tools to do this ? (I would prefer opensource, but if there is a well proven and affordable commercial app to do it, why not). Sincerly, -- Franck Coppola <[EMAIL PROTECTED]> Hexaglobe signature.asc

RE: [GENERAL] GIS-type databases using PostgreSQL

to be rewritten as they are not ISO19100 compliant. But all the concepts are there and working. The work doesn't stop here and include metadata schema, feature schema, but a the moment the crunch is creating a geographic object type in PG and rendering it. Cheers. Franck Martin Networ

[GENERAL] gmail screenshot...and Exchange server for linux?

ert it into the database. -Then you add some procedures and rules to the database, so that users can create custom rules to process the incoming messages. The result, you have created Exchange Server for Linux very quickly... Keep the good work. Cheers. Franck Martin [EMAIL PROTECTED]

RE: [GENERAL] GUI Interfaces

Check also gnomeDB on www.gnome.org go to office. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: http://www.sopac.org/ <http://www.sopac.org/> Support

[GENERAL] ISO SQL Geographic Objects

some examples of SQL representations. Thanks Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: http://www.sopac.org/ <http://www.sopac.org/> Support FMaps: http://fmap

[GENERAL] geoobj type

For the people interested, I have just commited in CVS of FMaps a new PostgreSQL type called geoobj. It is a very early release as I want to have early feedback. It is not complete and has many bugs, but it should give an overview of the type and the coding of it. It tries to follow the OpenGIS

[GENERAL] postgresql and Mandrake: no gist support?

I'm using Mandrake 7.2 and I cannot find the files gist.h and rtree.h in the postgres-devel rpm. Does anyone knows where are they ? Cheers. Franck Martin Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] Web site: http://www.sopa

[GENERAL] Indexing for geographic objects?

I'm building a new geo type and would like to index it. I have heard about RTREE and boundary box but I'm clueless for the moment about the implementation I have tried to look into PG source code to find the location where the indexing is done of current line object is done, but couldn't pin

RE: [GENERAL] Using BLOBs with PostgreSQL

PG definitively lack BLOB support and it is a big drawback... Even with PG7.1 with TOAST that will remove the 8kB limit on records, there will be still no BLOB support. As you have indicated it seems that PG chokes on null characters. What is needed is a varbinary type, which stores binary data

[GENERAL] Building a library for PG

figuration: Configure.in Makefile.am aclocal.m4 acconfig.h Thanks. Franck Martin Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: http://www.sopac.org/ <http://www.sopac.org/> This e-ma

Re: [GENERAL] Re: importing into postgres from access

seem to be the right > places. > > > > Thanks > > > > Steve > > http://www.openlinksw.com > > Alex Bolenok You can use the Windows ODBC driver of Postgresql and the use access to export your table to PG via ODBC. Maybe the Upsize wizard will even work... Cheers. Franck

RE: [GENERAL] unique row identifier data type exhausted . . .

you will need a lot of record you may decide to use 1, 2, or 3 numbers... Question, does postgress is able to run sequence on 2 combined numbers... Cheers... Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED

Max len record and how to access an array in binary

I would like to know the max length of a record containing arrays. How can I access the array field in binary form instead of ascii form. I'm using the pgsql library in C. Cheers. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission F

Re: [GENERAL] Future of PostgreSQL

twork config. Also, some XML import/export routine to import and export to tables... Relationships should be hardcoded in the database. Also, i'm not sure if it is part of current version, but we should be able to alter a field definition in a table without having to drop the table... Fra

[GENERAL] GIS and PostgreSQL ?

Does anybody know some GIS software used with PostgreSQL ? Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: www.sopac.org.fj <http://www.sopac.org.fj>

RE: [GENERAL] Oft Ask: How to contribute to PostgreSQL?

Does anybody know about some GIS or GPS software using PostgreSQL outside GRASS? Thanks. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: www.sopac.org.fj

[GENERAL] pb of library path

/test/regress. In this case the library libpq.sl was looked for in /usr/src/pgsql/src/interfaces/libpq so that worked out. How can I change the path of this library ? The path for libpq.sl should be /usr/local/pgsql/lib and it seems that this library is looked for in ../../interfaces/libpq ??? F

[GENERAL] compilation problems

I'm trying to compile postgres 6.3.2 on 10.20 hp-Ux 715 workstation and I've some trouble with it. In particular, I've error messages when it comes to the following: lex -t pgc.l > pgc.c "pgc.l" line 162: warning 22: Executable statements should occur right after %% "pgc.l" line 234: warning 48