* oleg@sai.msu.su (Oleg Bartunov) wrote:
|
| On Tue, 30 May 2006, Lars Haugseth wrote:
|
| I've setup a database using tsearch2, configured with support for compound
| words according to the excellent guide found here:
|
|
Hello !
We have a very sophisticated setup for our software which needs to
install databases on a PostgreSQL Server if the user chooses PG as
database system. This setup worked fine on 8.1 to 8.1.3 but fails now
with 8.1.4. It looks like the problem is caused by CREATEDB, which seems
to hang.
Hi list !
I have a small enterprise network (~15 workstations, 1 server),
all running windows OSes. Most of our work is done on a PostgreSQL
DB (on the windows server).
I am the only IT here, and my boss asked me to find a way to have
the database always online, without my intervention.
Last
Hi Arnaud,
perhaps you can still use Slony-I for replication and have another tool
automatically handle connections (check out PgPool[1] or SQLRelay[2]).
Or go for a middleware replication solution. Check C-JDBC[3], perhaps
there is something similar for ODBC?
LifeKeeper seems to handle
The latest version (V8.1.4) breaks the setup process of our
application's installation wizard. We used to call
createdb.exe and piped the password for the postgres user
(which has been entered by the user in our setup wizard's
dialogs) into it.
With version V8.1.4 this is not possible
Markus Schiltknecht a écrit :
Hi Arnaud,
perhaps you can still use Slony-I for replication and have another tool
automatically handle connections (check out PgPool[1] or SQLRelay[2]).
Or go for a middleware replication solution. Check C-JDBC[3], perhaps
there is something similar for ODBC?
Hi list !
I have a small enterprise network (~15 workstations, 1
server), all running windows OSes. Most of our work is done
on a PostgreSQL DB (on the windows server).
I am the only IT here, and my boss asked me to find a way to
have the database always online, without my intervention.
On Tue, 2006-05-30 at 22:47 +0200, Martijn van Oosterhout wrote:
That's why bytea need special encoding to get around this check.
But may be you would know, why I should write:
{ pg_type = DBD::Pg::PG_BYTEA }
instead of possibly more generic:
{ TYPE = SQL_BINARY }
The later
John DeSoi wrote:
I have a client that only supports Latin-1 and needs to connect to a
UTF-8 database to retrieve some data. Some columns may contain
characters that have no Latin-1 equivalent. I would like to convert
these to a blank or perhaps some hex value. Is there any way to do this
in
Hello,
3 weeks ago I install a PostgreSQL 8.1.3 server on
Windows 2003 server standar edition.
The box is a NEC express5800 TM800 with 4 SATA/300
250 Gb 7200 rpmin RAID10 (0+1).
It works fine, faster than the old server ALTOS
with SCSI-3 disks Ultra1601 rpm.
I upgraded to 8.1.4.
The
Martijn van Oosterhout wrote:
However, there is a solution: send the paramters seperate from the
query. In fact, postgres has been able to do that for a while now but
not all interfaces have been made to use it. My guess is that those
other databases you've used were already doing
Magnus Hagander a écrit :
Since you're a Windows shop, you may already have the experience (and
even liceneses perhaps?) to run Microsoft Cluster Service (part of 2003
Enterprise Edition or 2000 Advanced Server). PostgreSQL will work fine
with it. Works with shared disks using either
Pit M?ller wrote:
Hello !
We have a very sophisticated setup for our software which needs to
install databases on a PostgreSQL Server if the user chooses PG as
database system. This setup worked fine on 8.1 to 8.1.3 but fails now
with 8.1.4. It looks like the problem is caused by CREATEDB,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Arnaud Lesauvage
Sent: 31 May 2006 10:39
To: Magnus Hagander
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best high availability solution ?
Otherwise, is the clustering service
Dave Page a écrit :
Slony-I only exists for Windows in a not-even-beta state at the moment,
so even if you get things up and running using a virtual IP solution you
will be hand-holding Slony until it gets properly released.
OK, I thought it was in production stage.
If I'm honest, I think
On Wed, May 31, 2006 at 11:31:28AM +0200, Daniel Verite wrote:
Martijn van Oosterhout wrote:
However, there is a solution: send the paramters seperate from the
query. In fact, postgres has been able to do that for a while now but
not all interfaces have been made to use it. My guess
Arnaud Lesauvage schrieb:
...
I think you're right.
Is there a simple replication solution for windows then ? Or will I have
to stop the master postgresql at night to pgdump and pgrestore on the
backup server ?
pg_dump does not require you to stop the master database anyway.
(in fact it
-Original Message-
From: Arnaud Lesauvage [mailto:[EMAIL PROTECTED]
Sent: 31 May 2006 11:27
To: Dave Page
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best high availability solution ?
Dave Page a écrit :
Slony-I only exists for Windows in a not-even-beta state at
Arnaud Lesauvage schrieb:
Tino Wildenhain a écrit :
pg_dump does not require you to stop the master database anyway.
(in fact it cannot even dump a stopped database :-)
Hello Tino,
I think I might just use this pg_dump solution...
Seems to be quite simple to set up.
personally I think
Dave Page a écrit :
The code is written, and is good as far as we are aware, but has not been
through a beta/release cycle yet.
OK, that's already pretty good then.
Are there binary releases available ?
Is there a simple replication solution for windows then ? Or will
I have to stop the
-Original Message-
From: Arnaud Lesauvage [mailto:[EMAIL PROTECTED]
Sent: 31 May 2006 11:53
To: Dave Page
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best high availability solution ?
Dave Page a écrit :
The code is written, and is good as far as we are aware,
Tino Wildenhain a écrit :
personally I think the WAL approach is by far easier
to set up and maintain - the pg_dump is in fact easy,
but the restore to another database can be tricky
if you want it unattended and bullit-proof the same
time.
I'll have to study this more in-depth then.
If I got
Dave Page a écrit :
http://developer.pgadmin.org/~hiroshi/Slony-I/
That's built against 8.1 iirc.
Great !
USE AT YOUR OWN RISK!! IT MAY EAT YOUR DATA AND SET YOUR SERVER ON FIRE :-)
I'll keep an eye on it then ! ;-)
--
Arnaud
---(end of
Arnaud Lesauvage schrieb:
Tino Wildenhain a écrit :
personally I think the WAL approach is by far easier
to set up and maintain - the pg_dump is in fact easy,
but the restore to another database can be tricky
if you want it unattended and bullit-proof the same
time.
I'll have to study this
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tino
Wildenhain
Sent: 31 May 2006 12:14
To: Arnaud Lesauvage
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best high availability solution ?
Then with a script that would change my
Dave Page a écrit :
Yes - the DNS method would work, but you might run into caching issues
requiring the users to reboot or do a 'ipconfig /flushdns' before they
see the change.
Yes, but I am not a very nice adminsitrator, and when there is any
problem with a datawase, my users HAVE to reboot
Hi,
I'm desperately trying to post a message to this mailing-list since 10
o'clock this morning, although everything worked fine yesterday. I get no
error indicated my message is rejected, but nothing appears in the list.
Can anyone read this message?
--
Philippe
-Original Message-
From: Arnaud Lesauvage [mailto:[EMAIL PROTECTED]
Sent: 31 May 2006 12:33
To: Dave Page
Cc: Tino Wildenhain; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best high availability solution ?
Dave Page a écrit :
Yes - the DNS method would work, but you
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Philippe Lang
Sent: 31 May 2006 12:33
To: pgsql-general@postgresql.org
Subject: [GENERAL] Problems posting messages in this mailing-list?
Hi,
I'm desperately trying to post a message to this
Philippe Lang schrieb:
Hi,
...
Can anyone read this message?
No, sorry. Please repost.
Thx
Tino .-)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Dave Page a écrit :
Ah, but wasn't this intended for when you are not there standing over them with
a bat?
:-)
It was, but they know I will come back from vacation one day, and
then
;-)
--
Arnaud
---(end of broadcast)---
TIP 1: if
Hi,
I need to connect to remote databases using Dblink. Our existing version is
7.2.1 on Windows and please point me the location of this package where I can
download from and the installation procedure.
Thanks,
RamaKrishna.
---(end of
This is really strange... Is there an anti-spam software runnning on the
mailing-list server? Or maybe my english is too bad for the server...
Does anyone have access to the /var/maillog of the mailing-list server?
-Message d'origine-
De : Dave Page [mailto:[EMAIL PROTECTED]
Envoyé :
Hi,
For an unknown reason, I cannot post this message to the mailing-list!
Here it is:
http://www.attiksystem.ch/postgresql-general.txt
Cheers,
Philippe Lang
smime.p7s
Description: S/MIME cryptographic signature
In the last exciting episode, dpage@vale-housing.co.uk (Dave Page) wrote:
If I'm honest, I think your boss is going to be disappointed. You
would add a *lot* of complexity to the system to make it handle
failures with zero intervention, and that extra complexity is
probably more likely to go
On May 31, 2006, at 5:17 AM, Nis Jorgensen wrote:
You should be able to do this with regular expressions
(substituting all
invalid chars) on the text columns of the result set(s). I write
should be, since I don't remember the capabilities of pg regular
expressions.
I thought about this,
On Wednesday 31 May 2006 07:51 am, Tino Wildenhain [EMAIL PROTECTED] thus
communicated:
-- Philippe Lang schrieb:
-- Hi,
-- ...
-- Can anyone read this message?
--
-- No, sorry. Please repost.
--
-- Thx
-- Tino .-)
--
:oD
---(end of
Bruce Momjian wrote:
Pit M�ller wrote:
Hello !
We have a very sophisticated setup for our software which needs to
install databases on a PostgreSQL Server if the user chooses PG as
database system. This setup worked fine on 8.1 to 8.1.3 but fails now
with 8.1.4. It looks like the problem
I have a client that only supports Latin-1 and needs to connect to a
UTF-8 database to retrieve some data. Some columns may contain
characters that have no Latin-1 equivalent. I would like to convert
these to a blank or perhaps some hex value. Is there any way to do
this in PostgreSQL
Stuart Bishop a écrit :
If your application is normally reliable, I think the best, cheapest and
simplest way of keeping the system online when you are on leave is to give
your work the phone number of a company offering PostgreSQL support
services. I would avoid adding the extra complexity and
Since you're a Windows shop, you may already have the
experience (and
even liceneses perhaps?) to run Microsoft Cluster Service
(part of 2003
Enterprise Edition or 2000 Advanced Server). PostgreSQL will
work fine
with it. Works with shared disks using either fibrechannel or iSCSI.
Hi :
Maybe you forget to run the ANALYZE command afterwards.
ludwig.
--- Philippe Lang [EMAIL PROTECTED] wrote:
Hi,
For an unknown reason, I cannot post this message to the
mailing-list!
Here it is:
http://www.attiksystem.ch/postgresql-general.txt
Cheers,
Philippe Lang
Arnaud Lesauvage wrote:
Hi list !
I have a small enterprise network (~15 workstations, 1 server), all
running windows OSes. Most of our work is done on a PostgreSQL DB (on
the windows server).
I am the only IT here, and my boss asked me to find a way to have the
database always online,
Hi,
I did not mention it in my first email, but I did run ANALYSE before
running the query... So statistics are just fine for the execution plan
engine.
Philippe
-Message d'origine-
De : Ludwig Isaac Lim [mailto:[EMAIL PROTECTED]
Envoyé : mercredi, 31. mai 2006 15:52
À : Philippe Lang
At 10:38 AM 5/31/2006 +0200, Magnus Hagander wrote:
Since you're a Windows shop, you may already have the experience (and
even liceneses perhaps?) to run Microsoft Cluster Service (part of 2003
Enterprise Edition or 2000 Advanced Server). PostgreSQL will work fine
with it. Works with shared
I am creating a Windows Forms App that uses PGSQL 8.1.4 for
the database. The database will be installed on the client, and the server.
I will only need to keep a few tables, not the whole
database synchronised. Is it better to manage this with my app?, or does PGSQL
support some decent
Hi:
How about the postgresql.conf settings? Did you changed
them?
ludwig.
--- Philippe Lang [EMAIL PROTECTED] wrote:
Hi,
I did not mention it in my first email, but I did run
ANALYSE before
running the query... So statistics are just fine for the
execution plan
engine.
Philippe
Hi,
No, the only change I made in postgresql.conf is in order to have the
postmaster listen on the network, and change the default datestyle, just
like I did with all the other installations.
Philippe
-Message d'origine-
De : Ludwig Isaac Lim [mailto:[EMAIL PROTECTED]
Envoyé :
On May 31, 2006, at 9:26 AM, Tatsuo Ishii wrote:
It should be easy to write user defined funtion and define your own
CONVERSION. CREATE CONVERSION is your friend.
It looks like CREATE CONVERSION requires a C function to do the
conversion. This will be used in a hosted environment -- I
Philippe Lang [EMAIL PROTECTED] writes:
http://www.attiksystem.ch/postgresql-general.txt
Please provide EXPLAIN ANALYZE, not just EXPLAIN, output ... and try to
post it in an un-line-wrapped form.
Also, as Ludwig mentioned, a common gotcha is to forget to ANALYZE your
data after moving it to a
On May 31, 2006, at 9:17 AM, Nis Jorgensen wrote:
regexp_replace seems to do what you need:
http://www.postgresql.org/docs/8.1/static/functions-matching.html
Something like
regexp_replace (field, '[^\u-\u00FF]', '?', 'g')
Yes! Thanks very much -- I looked at that page several times
I am trying to get PostgreSQL 8.1.4 up and running on fedora core 5. Upon trying to add a user (I had to use the createuser command) I recieved this error: [EMAIL PROTECTED] postgresql-8.1.4]# createuser postgresShall the new role be a superuser? (y/n) ycreateuser: could not connect to database
Philippe Lang wrote:
Hi,
For an unknown reason, I cannot post this message to the mailing-list!
Here it is:
http://www.attiksystem.ch/postgresql-general.txt
Please post query and table structure as well. And since you are using a
medium with no limitation on line lenght, unwrap the query
On Wed, May 31, 2006 at 09:36:23 +0200,
Arnaud Lesauvage [EMAIL PROTECTED] wrote:
I am the only IT here, and my boss asked me to find a way to have
the database always online, without my intervention.
Last time I went on vacation, the server crashed and no one was
able to repair it.
Your
Bruno Wolff III a écrit :
On Wed, May 31, 2006 at 09:36:23 +0200,
Arnaud Lesauvage [EMAIL PROTECTED] wrote:
I am the only IT here, and my boss asked me to find a way to have
the database always online, without my intervention.
Last time I went on vacation, the server crashed and no one was
Hi,
I have now disabled hyperthreading in /etc/grub.conf (added noht at the end
of kernel lines), rebooted the server, run ANALYSE on the database again,
and launched the query: things are even a little bit worse, it completes in
540 seconds now. So this is no ANALYSE or hyperthreading problem.
jonathan harvey [EMAIL PROTECTED] writes:
I am trying to get PostgreSQL 8.1.4 up and running on fedora core 5.
Have you started the service? If ps auxww | grep postgres doesn't
show some postgres-owned processes, you need
sudo /sbin/service postgresql start
You probably also want
On May 31, 2006, at 10:40 AM, John DeSoi wrote:
Yes! Thanks very much -- I looked at that page several times and
missed regexp_replace.
Ok, now I know why I missed it. regexp_replace is only in PostgreSQL
8.1 and later. I'm stuck with 8.0 for hosting at the moment.
I'm sure it is not
I agree with you, but I will have two servers : one will be the file
server, the primary controller of the active directory, and the backup
of postgresql; the other one will be the postgresql server and the
backup of the file server and active directory.
So restoring from this situation does
Hi,
I wanna make a web-based program.
The program stores the datas in a PG database. A lot of user can be, and
the filling of data web forms could take 30 sec -1 min.
My idea is to handle the connection between the C program and the
database: using only ONE PGuser, and at the beginig of data
[EMAIL PROTECTED] (Riccardo Inverni) writes:
I have to update a Linux box with PostgreSQL on it, essentially
for data warehousing purposes. I had set it up about 3 years ago and
at that time the best solution I had been recommended was to use
SCSI disks with hardware RAID controllers.
Hi:
Just a hunch:
What about adding an index to the field
etapes_lignes_commandes(code_etape). Assuming your database
uses C locales. This might work for your particular query
since your filter is something like code_etape~~'COMP%'.
What about increasing the settings of work_mem, etc
Philippe Lang [EMAIL PROTECTED] writes:
Here are both EXPLAIN ANALYSE results, plus the query itself:
Postgresql 7.4.5: http://www.attiksystem.ch/explain_analyze_74.txt
Postgresql 8.1.4: http://www.attiksystem.ch/explain_analyze_81.txt
Query is here: http://www.attiksystem.ch/big_query.txt
My
When we were trying to do DW stuff on Linux + Opteron + FibreChannel +
EMC DiskArray, we too frequently found filesystems keeling over. It
was neither cheap nor reliable.
When is When? Not trying to start a flame war but I am curious as to
your specifications to make this stuff work. Was it
Should be no problem, a lot of systems work like this. Also see
pgpool which can be used to minimize the overhead of opening and
closing connections.
http://pgpool.projects.postgresql.org/
On May 31, 2006, at 11:36 AM, Bali László wrote:
I wanna make a web-based program.
The program
OK, thnx.
2006. 05. 31, szerda keltezéssel 13.24-kor John DeSoi ezt írta:
Should be no problem, a lot of systems work like this. Also see
pgpool which can be used to minimize the overhead of opening and
closing connections.
http://pgpool.projects.postgresql.org/
On May 31,
On Wed, 2006-05-31 at 06:47, Ramakrishna Reddy wrote:
Hi,
I need to connect to remote databases using Dblink. Our existing version is
7.2.1 on Windows and please point me the location of this package where I can
download from and the installation procedure.
You should REALLY REALLY
Hi,
Thanks for your vauable suggestions.
We have very huge databases in many installations and infact have plans for
upgrading to latest releases. But as we are not very sure about the stability
of post 7.2.1 versions, refrained from doing that. Could you please suggest me
which version is
[EMAIL PROTECTED] (Joshua D. Drake) writes:
When we were trying to do DW stuff on Linux + Opteron + FibreChannel +
EMC DiskArray, we too frequently found filesystems keeling over. It
was neither cheap nor reliable.
When is When? Not trying to start a flame war but I am curious as to
your
On Wed, 2006-05-31 at 12:57, Ramakrishna Reddy wrote:
Hi,
Thanks for your vauable suggestions.
We have very huge databases in many installations and infact have plans for
upgrading to latest releases. But as we are not very sure about the stability
of post 7.2.1 versions, refrained
I wrote:
So basically 8.1 is being too optimistic about the value of ANDing
multiple indexes. If you try setting enable_bitmapscan off, you'll
probably find 8.1 beating 7.4 handily for this query. That's a really
blunt-instrument solution of course, and I wouldn't recommend it for
On 5/31/06, Joshua D. Drake [EMAIL PROTECTED] wrote:
When we were trying to do DW stuff on Linux + Opteron + FibreChannel +
EMC DiskArray, we too frequently found filesystems keeling over. It
was neither cheap nor reliable.
I completely agree with the above statements with a small
Hi,
I am working on a dependency/referenced by viewer and given a query like so:
select refobjid from pg_depend where objid = 91640
how do I determine what refobjid is? is there a function or something I
have missed or do I just run brute force queries against the system tables?
Thanks in
On Wed, May 31, 2006 at 02:10:38PM -0500, Tony Caduto wrote:
Hi,
I am working on a dependency/referenced by viewer and given a query like so:
select refobjid from pg_depend where objid = 91640
how do I determine what refobjid is? is there a function or something I
have missed or do I just
Hola a todos
Estoy trabajando con postgresql y tengo el siguiente problema
cuando intento listar todas las bases de datos existentes con psql -l
me sale el siguiente error:
ERROR: no existe la relación pg_catalog.pg_user
Puedo crear bases de datos y acceder a ellas sin problema
Que puede
Reid Thompson wrote:
PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used
for test/dev.
This installation has been working fine for quite a while. I've used
it minimally.
I rebooted yestderday- log file from reboot
2006-05-18 12:24:32 LOG: database system was shut down at
I want to move a windows server 2003 based postgres database
from one server to another server, can I just copy and paste the base folder or
do I have to do a backup and restore? If so what options work best for creating
a file to move?
Edward Coyle
Intellecare, Inc.
Your query is ambiguous.
Probably, you are looking for SLONY.
http://gborg.postgresql.org/project/slony1/projdisplay.php
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg
Sent: Wednesday, May 31, 2006 7:13 AM
To:
Eliana Providel wrote:
Hola a todos
Estoy trabajando con postgresql y tengo el siguiente problema
cuando intento listar todas las bases de datos existentes con psql -l
me sale el siguiente error:
ERROR: no existe la relación pg_catalog.pg_user
Puedo crear bases de datos y acceder a ellas
[EMAIL PROTECTED] (Merlin Moncure) writes:
Xyratex
From their web site, they sound like they'll be as challenging to get
straight answers from as any of the other disk array vendors :-(.
And there's nothing about what I see there that seems to address
anything at all about the instability
[EMAIL PROTECTED] (Ramakrishna Reddy) writes:
Thanks for your vauable suggestions.
We have very huge databases in many installations and infact have
plans for upgrading to latest releases. But as we are not very sure
about the stability of post 7.2.1 versions, refrained from doing
that.
It should be easy to write user defined funtion and define your own
CONVERSION. CREATE CONVERSION is your friend.
It looks like CREATE CONVERSION requires a C function to do the
conversion. This will be used in a hosted environment -- I won't be
able to add any C language functions.
I am getting an error when I import, invalid input syntax for type
boolean - which is empty. Is there any way around this of must I
necessarily have \N ?
Craig
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Chris Browne [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] (Ramakrishna Reddy) writes:
We have very huge databases in many installations and infact have
plans for upgrading to latest releases. But as we are not very sure
about the stability of post 7.2.1 versions, refrained from doing
that.
John DeSoi wrote:
On May 31, 2006, at 10:40 AM, John DeSoi wrote:
Yes! Thanks very much -- I looked at that page several times and
missed regexp_replace.
Ok, now I know why I missed it. regexp_replace is only in PostgreSQL 8.1
and later. I'm stuck with 8.0 for hosting at the moment.
I'm
strugging to import
I connect and am on the command line but I don't think I am in the right
schema. I have looked through the /h /? but can't seem to figure out how
to change to
database: th-db
schema: db
version: # rpm -q postgresql
postgresql-7.4.8-1.RHEL4.1
Craig
Hi
Please, how I can create an insert (dynamic?) query from a PGresult
struct (libpq-fe.h) ? I create this PGresult with a PQexec(..SELECT *
FROM table..
and update ?
Any sample ?
thanks to all !
---(end of broadcast)---
TIP 2: Don't 'kill
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rafal Pietrak asked:
2. I admitt, that I should have spotted myself, that the
DBD::Pg::PG_BYTEA might not have been recognized without the use
clausure, but the driver itself understands prity much of the
underlaying datatypes - I fon't need to
Craig White wrote:
strugging to import
I connect and am on the command line but I don't think I am in the right
schema. I have looked through the /h /? but can't seem to figure out how
to change to
database: th-db
schema: db
version: # rpm -q postgresql
postgresql-7.4.8-1.RHEL4.1
You'll
Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from one
server to another server, can I just copy and paste the base folder or
do I have to do a backup and restore? If so what options work best for
creating a file to move?
I think if you shut down postgresql
Craig White wrote:
I am getting an error when I import, invalid input syntax for type
boolean - which is empty. Is there any way around this of must I
necessarily have \N ?
They will have to be changed to nulls - the boolean type only allows
true, false or null:
On May 31, 2006, at 9:18 PM, Chris wrote:
Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from
one server to another server, can I just copy and paste the base
folder or do I have to do a backup and restore? If so what options
work best for creating a file
On Wed, May 31, 2006 at 15:34:46 -0500,
Edward Coyle [EMAIL PROTECTED] wrote:
I want to move a windows server 2003 based postgres database from one server
to another server, can I just copy and paste the base folder or do I have to
do a backup and restore? If so what options work best for
Jim Nasby wrote:
On May 31, 2006, at 9:18 PM, Chris wrote:
Edward Coyle wrote:
I want to move a windows server 2003 based postgres database from one
server to another server, can I just copy and paste the base folder
or do I have to do a backup and restore? If so what options work best
for
Chris [EMAIL PROTECTED] writes:
Jim Nasby wrote:
Actually, as long as you're not changing major versions (ie: 8.0.x to
8.1.x) you'll be fine.
I wasn't sure if changes like 8.1.x to 8.1.4 would cause a problem here:
We have a project policy that we *never* force initdb in a minor
release.
Chris [EMAIL PROTECTED] writes:
Craig White wrote:
I am getting an error when I import, invalid input syntax for type
boolean - which is empty. Is there any way around this of must I
necessarily have \N ?
You could try with:
COPY ... WITH NULL AS ''
--
greg
96 matches
Mail list logo