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 t
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 replicat
> 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 p
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?
Lif
> 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 interve
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 P
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 rpm in RAID10 (0+1).
It works fine, faster than the old server ALTOS
with SCSI-3 disks Ultra160 1 rpm.
I upgraded to 8.1.4.
The e
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 fibrechannel
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 CREAT
> -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 ser
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 you
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. M
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 cann
> -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
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 the
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 mast
> -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
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 i
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 broadcast)-
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 m
> -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
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,
> -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
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 pos
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 broadcast)
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é : me
Tino Wildenhain a écrit :
If I understand you right, you suggest that the wal files should be
automatically copied to the backup server, which should parse them as
soon as they arrive ?
eactly.
Indeed, it seems to be the best solution !
After reading the backup-online page, I see that the re
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
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 broadcast)-
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
> 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 Postgr
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 a
> >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
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,
>
> Phi
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 onlin
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 Lan
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 disk
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 sy
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.
>
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é : mercredi,
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 won'
"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 t
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 and
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 p
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 pla
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.
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.
H
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 ve
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 n
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 inser
[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 (check
"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.
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 k
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 sto
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
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 R
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 t
[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
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, refrai
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
> produ
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 obje
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 adv
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
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.
Phone-972-919-900
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: pgsql-general@postgresql.o
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 h
[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
> t
> > 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 func
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
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
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 need
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:
http://www.postgresql.org/doc
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 t
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 cr
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
rel
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
