On Donnerstag, 14. Mai 2009, Philipp Marek wrote:
> On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote:
> > Philipp Marek wrote:
> > > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > > Do say, do you have any long-running transactions, or "idle"
> > > > transactions? Maybe someone opened a t
makes you wonder what possible use a MH_DYLIB library might serve
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note de
déni et de confidentialité
This message is confidential. If you should not be the intended receiv
Tom Lane wrote:
> I don't recall the details at the moment, but I think we intentionally
> didn't adopt the .dylib extension for these files because of some subtle
> difference between them and plain shared libraries.
If I recall correctly from porting a plugin-based app to Mac OS X a few
years a
On Thu, May 14, 2009 at 07:39:41PM -0400, Steven Lembark wrote:
>
> > Which "warnings" are you talking about? I thought you said you had
> > plain SQL working OK, but were struggling to pass parameters containing
> > UTF-8 encoded characters.
> >
> > Are you sure that your Perl code is passing t
> Which "warnings" are you talking about? I thought you said you had
> plain SQL working OK, but were struggling to pass parameters containing
> UTF-8 encoded characters.
>
> Are you sure that your Perl code is passing the string encoded as UTF8?
Excellent point: Perl will only pass through the
On Thu, May 14, 2009 at 11:21 PM, Raymond O'Donnell wrote:
> On 14/05/2009 23:11, Casey,Richard wrote:
>
>> Does anyone know where to download version 8.3.7 of the files
>> pg_dump.exe and pg_dumpall.exe?
>
> I don't think the Windows binaries are available for separate download
> (which is a grea
On 14/05/2009 23:21, Raymond O'Donnell wrote:
> On 14/05/2009 23:11, Casey,Richard wrote:
>
>> Does anyone know where to download version 8.3.7 of the files
>> pg_dump.exe and pg_dumpall.exe?
>
> I don't think the Windows binaries are available for separate download
> (which is a great pity IMHO
On 14/05/2009 23:11, Casey,Richard wrote:
> Does anyone know where to download version 8.3.7 of the files
> pg_dump.exe and pg_dumpall.exe?
I don't think the Windows binaries are available for separate download
(which is a great pity IMHO - 'twould be very handy betimes).
However, you could down
Hello,
Does anyone know where to download version 8.3.7 of the files pg_dump.exe and
pg_dumpall.exe?
Richard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks everyone for the many responses to this question. Asynchronous
schema updates may be how we'll have to proceed, but we'd really like to
avoid that. Instead, I'm currently studying the possibility of a
my_create_table() function that accepts a CREATE TABLE command, executes
the command, and a
The functions, encode, converts the binary string to HEX representation. It
does seem to work as mysql's blob accepts the HEX data representation. Any
program that you are aware of for dumping the data to the SQL script (i.e.
INSERT INTO ...) while having the option to convert those binary string t
On 14/05/2009 20:07, George Kao wrote:
> The data in escaped octal is not acceptable. Is there a way to dump the
> bytea from posgresql database in hex format? I think it is acceptable by
No, I'm fairly sure that you can't do it directly in the pg_dump output.
However, you could maybe use the func
Thanks for the replying.
The problem has been narrowed down to restoring a particular table with
Bytea field to Mysql database.
The data in escaped octal is not acceptable. Is there a way to dump the
bytea from posgresql database in hex format? I think it is acceptable by
mysql.exe.
George
-
wickro writes:
> So this is a planning mistake? Should a hash be allowed to grow larger
> than work_mem before it starts to use the disk?
HashAggregate doesn't have any ability to spill to disk. The planner
will not select a HashAggregate if it thinks the required hash table
would be larger than
On 14/05/2009 14:18, George Kao wrote:
> The platform is WinXP. I have database with fields of bytea in Posgresql
> 8.1. The objective was to transfer the entire databasae (schema + data)
> to Mysql 5.1. I used the pg_dump from Posgresql 8.1 to extract the
> schema and data. With some minor touch-u
On Thu, May 14, 2009 at 01:57:04PM -0400, Steven Lembark wrote:
> On Thu, 14 May 2009 18:44:57 +0100 Sam Mason wrote:
> > You want to be using whatever language you're generating the parameter
> > from (Perl) to handle the expansion of escape sequences for you. This
> > will cause the expanded st
You're right. At a certain work_mem threshold it switches over to a
HashAggregate sort method.
When it does, it eats up alot of memory. For GroupAggregate it only
uses the max of work_mem.
I'm using Postgresql 8.3.3 64bit on Centos 5.
The query I'm running is:
select keyword, partner_id, sum(num_
On Thu, 14 May 2009 18:44:57 +0100
Sam Mason wrote:
> You want to be using whatever language you're generating the parameter
> from (Perl) to handle the expansion of escape sequences for you. This
> will cause the expanded string (i.e. the escapes have been interpreted)
> to be sent to Postgres
On Thu, May 14, 2009 at 11:25:33AM -0400, Steven Lembark wrote:
> Q: Is there any combination of locale, encoding,
>client_encoding or functions that will allow
>me to insert values with these escape sequences
>without getting the warnings?
>
> Trying this in psql with various combina
On Thu, May 14, 2009 at 05:21:41AM -0700, RaviThapliyal wrote:
> Can postgresql be installed on windows 98 OS?
>
> I want to install windows application with postgresql as a backend database
> in Windows 98 machine.
Ravi: just to confirm; you have several "client companies" that run MS
Windows 98
Quoting wickro :
I have a largish table (> 8GB). I'm doing a very simple single group
by on.
This doesn't answer your question, but you might want to take
advantage of table partitioning:
http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html
I've recently gone through this ex
I have tried to pg_dump only one single table with bytea field and the
result is the same when I come to restore with mysql.
-Original Message-
From: Allan Kamau [mailto:all...@sanbi.ac.za]
Sent: Thursday, May 14, 2009 11:15 AM
To: Postgres-General
Cc: George Kao
Subject: Re: [GENERAL] ho
Using Postgres 8.3 with DBI 1.607, DBD::Pg 2.12.0, perl v5.10.0,
I am trying to insert the medline database
contents, which include non-ascii char's,
hopefully using a prepared query.
Playing with the locale, encoding,
client_encoding, standard_conforming_strings,
leaves me able to insert val
Jonathan Groll writes:
> On Wed, May 13, 2009 at 09:54:56AM -0400, Tom Lane wrote:
>> I find this pretty suspicious. On my OSX machine, the contents of the
>> pkglibdir directory are all named something.so:
>> dict_snowball.so* utf8_and_euc_jp.so*
> And mine are also .so af
Hi George,
This is my guess to the cause of the problem (I could be wrong).
You edited the pg_dump generated sql file to suit to suit the
requirements of your target server (MySQL), during this edition, your
editor may have inserted line terminators where it found long sentences,
this long sen
RaviThapliyal wrote:
but i need to run postgresql on windows98. Many of our clients are
working on windows98 :(.
Any way out for this?
run the postgres CLIENT on the client machines, and run the postgres
SERVER on a server.
--
Sent via pgsql-general mailing list (pgsql-general@post
On Wed, May 13, 2009 at 09:54:56AM -0400, Tom Lane wrote:
Jonathan Groll writes:
Custom built postgresql 8.3.5 using the pkgsrc build system on OS X
Leopard;
Uh ... what is the "pkgsrc build system", and what changes does it make
to a straight-from-source PG build?
Pkgsrc is the netbsd pack
wickro writes:
> Hi everyone,
>
> I have a largish table (> 8GB). I'm doing a very simple single group
> by on. I am the only user of this database. If I set work mem to
> anything under 2GB (e.g. 1900MB) the postmaster process stops at that
> value while it's peforming it's group by. There is on
wickro writes:
> I have a largish table (> 8GB). I'm doing a very simple single group
> by on. I am the only user of this database. If I set work mem to
> anything under 2GB (e.g. 1900MB) the postmaster process stops at that
> value while it's peforming it's group by. There is only one hash
> oper
On Thursday 14 May 2009 5:38:44 am RaviThapliyal wrote:
> Thanks Raymond for the quick reply, but i have certain limitation to this.
>
> I had created a standalone application on postgresql as a backend database
> considering windows xp but now i have learnt that some clients are still
> working on
I maintain a warm backup site at a co-location in another city. One
of the things that gets moved there is a copy of the PostgreSQL
backend for our company wiki and project management site. This is a
simple process of dumping the database, rsyncing to the remote site
and restoring. The relevant
I've got Postgres running on colinux which works well under windows
XP, not sure how it will do under windows '98.
(Not very well, according to this:
http://colinux.wikia.com/wiki/FAQ#Q11._Is_it_possible_to_run_coLinux_under_98.2FME.3F
)
2009/5/14 Richard Huxton :
> Well, the perhaps more generou
2009/5/14 Devrim GÜNDÜZ :
> On Thu, 2009-05-14 at 06:51 -0700, SHARMILA JOTHIRAJAH wrote:
>> I'm trying to get a good postgresql book for reference. I love the
>> Postgresql manual but I would also like to keep a good PG book handy.
>
> ...then print PostgreSQL manual ;)
>
That's i call a good poi
On Thu, 2009-05-14 at 06:51 -0700, SHARMILA JOTHIRAJAH wrote:
> I'm trying to get a good postgresql book for reference. I love the
> Postgresql manual but I would also like to keep a good PG book handy.
...then print PostgreSQL manual ;)
Known books are here:
http://www.postgresql.org/docs/books
2009/5/14 SHARMILA JOTHIRAJAH :
> Hi,
> I'm trying to get a good postgresql book for reference. I love the
> Postgresql manual but I would also like to keep a good PG book handy.
> Any suggestions?
> Thanks
>
>
>
The Douglas book still very good (but also's old) "postgresql handbook".
The Peter E
Hi everyone,
I have a largish table (> 8GB). I'm doing a very simple single group
by on. I am the only user of this database. If I set work mem to
anything under 2GB (e.g. 1900MB) the postmaster process stops at that
value while it's peforming it's group by. There is only one hash
operation so tha
On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote:
> Philipp Marek wrote:
> > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > Do say, do you have any long-running transactions, or "idle"
> > > transactions? Maybe someone opened a terminal somewhere and left it
> > > open for days? Have a l
Hi,
I'm trying to get a good postgresql book for reference. I love the Postgresql
manual but I would also like to keep a good PG book handy.
Any suggestions?
Thanks
Bill Moran wrote:
In response to RaviThapliyal :
but i need to run postgresql on windows98. Many of our clients are
working on windows98 :(.
Any way out for this?
No. The correct answer to this question is "you can't do this, and if
you figure out a hack to make it work, you will be sor
The platform is WinXP. I have database with fields of bytea in Posgresql
8.1. The objective was to transfer the entire databasae (schema + data)
to Mysql 5.1. I used the pg_dump from Posgresql 8.1 to extract the
schema and data. With some minor touch-up of the sql script generated, I
am able to run
Greetings to everyone!
GlusterFS is a clustered file system that runs on commodity
off-the-shelf hardware, delivering multiple times the scalability and
performance of conventional storage. The architecture is modular,
stackable and kernel-independent, which makes it easy to customize,
install, m
Philipp Marek wrote:
> On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > we're using postgresql 8.3 for some logging framework.
> > >
> > > There are several tables for each day (which are inherited from a common
> > > base), which
> > > - are filled during the day,
> > > - after midnight the
In response to RaviThapliyal :
>
> but i need to run postgresql on windows98. Many of our clients are
> working on windows98 :(.
> Any way out for this?
No. The correct answer to this question is "you can't do this, and if
you figure out a hack to make it work, you will be sorry that you d
On 14/05/2009 13:38, RaviThapliyal wrote:
> Thanks Raymond for the quick reply, but i have certain limitation to this.
>
> I had created a standalone application on postgresql as a backend database
> considering windows xp but now i have learnt that some clients are still
> working on windows 98 O
Craig Ringer, 14.05.2009 14:31:
You really, really, REALLY don't want to run the server on win98.
That should be:
You really, really, REALLY don't want to run Win98 :)
SCNR
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
but i need to run postgresql on windows98. Many of our clients are
working on windows98 :(.
Any way out for this?
--
View this message in context:
http://www.nabble.com/postgresql-on-windows98-tp23539453p23539793.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Thanks Raymond for the quick reply, but i have certain limitation to this.
I had created a standalone application on postgresql as a backend database
considering windows xp but now i have learnt that some clients are still
working on windows 98 OS.
So is there any way out for windows98 to act as
RaviThapliyal wrote:
Can postgresql be installed on windows 98 OS?
I want to install windows application with postgresql as a backend database
in Windows 98 machine.
I think the non-unicode ODBC driver should work on Win98.
You really, really, REALLY don't want to run the server on win98. Ru
On 14/05/2009 13:21, RaviThapliyal wrote:
> Can postgresql be installed on windows 98 OS?
>
> I want to install windows application with postgresql as a backend database
> in Windows 98 machine.
>
AFAIK, no; on Windows it needs an NT-type OS on which to run.
Does cygwin work on Win98? - you mig
Can postgresql be installed on windows 98 OS?
I want to install windows application with postgresql as a backend database
in Windows 98 machine.
Any help or comment will be appreciated.
Thanks in Advance
--
View this message in context:
http://www.nabble.com/postgresql-on-windows98-tp23539453p
50 matches
Mail list logo
