John DeSoi skrev:
There are highly productive IDEs for the Mac with all the goodies you
mention. But few are cross-platform.
Your statement about Windows desktop market share is correct, but it is
not the relevant point. Many people are interested in cross-platform
tools because they want to
Ashish Karalkar wrote:
Thanks Chris ,
I ahve checked the permissions on the xxid.so file and
it ids having all permission i.e. 0777
I think its not getting the permission from the object
which xxid.so is refering, any idea which object it is
refering
Are you running SeLinux by any chance? T
Thanks Chris ,
I ahve checked the permissions on the xxid.so file and
it ids having all permission i.e. 0777
I think its not getting the permission from the object
which xxid.so is refering, any idea which object it is
refering
With Regards
Ashish Karalkar
--- Chris <[EMAIL PROTECTED]> wrote:
Ashish Karalkar wrote:
I am having PostgreSQL 8.1.5 binary loaded on linux
machine.
I am using Slony 1.2.1 for replication database.Bothe
master and slave will be on localhost, while
configuring the database I am getting following error
massage.
could not load library "/usr/lib/pgsql/xxid.so":
On Tue, 2006-11-28 at 22:59 -0500, Bruce Momjian wrote:
> Richard Broersma Jr wrote:
> > > Sure, see the psql manual page, but setting EDITOR is the easiest way.
> > > This works on Win32 too.
> >
> > c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe"
> >
> > Thanks Bruce, this worked like a ch
I am having PostgreSQL 8.1.5 binary loaded on linux
machine.
I am using Slony 1.2.1 for replication database.Bothe
master and slave will be on localhost, while
configuring the database I am getting following error
massage.
could not load library "/usr/lib/pgsql/xxid.so":
/usr/lib/pgsql/xxid.so: f
Hi Ritesh,
On Nov 28, 2006, at 8:53 PM, Ritesh Nadhani wrote:
I see that pgEdit is for both Windows and Mac. Which toolkit did you
use to develop it and what are your primary development environment?
pgEdit is written in Lisp with LispWorks (http://www.lispworks.com).
It has a pretty nice c
> Richard Broersma Jr wrote:
> > > Sure, see the psql manual page, but setting EDITOR is the easiest way.
> > > This works on Win32 too.
> >
> > c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe"
> >
> > Thanks Bruce, this worked like a charm!
> >
> > And sorry to drag this, but does anyone kn
Richard Broersma Jr wrote:
> > Sure, see the psql manual page, but setting EDITOR is the easiest way.
> > This works on Win32 too.
>
> c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe"
>
> Thanks Bruce, this worked like a charm!
>
> And sorry to drag this, but does anyone know the windows (xp
> Sure, see the psql manual page, but setting EDITOR is the easiest way.
> This works on Win32 too.
c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe"
Thanks Bruce, this worked like a charm!
And sorry to drag this, but does anyone know the windows (xp) equivalent to:
/etc/rc.conf for *nix? i.e
Hello John
I see that pgEdit is for both Windows and Mac. Which toolkit did you
use to develop it and what are your primary development environment?
Ritesh
On 11/28/06, John DeSoi <[EMAIL PROTECTED]> wrote:
On Nov 28, 2006, at 2:05 PM, Tony Caduto wrote:
> They are serious applications, but
Hey
Sorry for the critical mistake. Pressed the SEND button too early. In
the first para I meant:
The reason I *want* to develop the project in wxWindows or a C/C++
based toolkit is that in the end I would be able to compile a binary
which will have least dependency and can be bundled for downlo
Hello All
Sorry for the late reply. Been a little busy with my assignments.
I will try to answer all the queries in this mail.
The reason I don't want to develop the project in wxWindows or a C/C++
based toolkit is that in the end I would be able to compile a binary
which will have least depend
On Nov 28, 2006, at 2:05 PM, Tony Caduto wrote:
They are serious applications, but they don't exactly have a lot of
forms and look how long Mozilla was in development.
I think the various interfaces in something like Thunderbird shows it
can do all the standard GUI stuff pretty well.
The
Richard Broersma Jr wrote:
> Does anyone know how to change the default editor from NOTEPAD to something
> link gVim? It would be
> nice to use an editor with a little more smarts.
Sure, see the psql manual page, but setting EDITOR is the easiest way.
This works on Win32 too.
--
Bruce Momjia
Does anyone know how to change the default editor from NOTEPAD to something
link gVim? It would be
nice to use an editor with a little more smarts.
Regards,
Richard Broersma jr.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
Martijn van Oosterhout writes:
> Hmm? To upgrade libc.so you merely need to delete the old one and
> install the new one, there's no need to preserve the inode. The mmap()
> is private, but no, Linux does not keep a backup copy of the shared
> library if you overwrite it. The behaviour of overwrit
> no cigar.
Well, duh. Showing why IS DISTINCT FROM is useful.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgr
On Nov 28, 2006, at 12:07 PM, Edwin Grubbs wrote:
Under postgres 8.1, the "<<=" comparison yields very slow queries
with large tables. I can rewrite the query without the "<<="
operator by generating all 33 possible netmasks (0 through 32) for
a given IP. This ugly rewrite runs about 12 ti
On Tue, Nov 28, 2006 at 04:09:11PM -0500, Tom Lane wrote:
> The mmap man page is pretty vague on the subject, but I wonder whether
> the shlib isn't effectively treated as copy-on-write --- that is, any
> attempted overwrite of the file happens only after the mmap region has
> been fully copied. W
I was wrong from the get-go, I apparently selected the cube contrib, because
on reinstall it's not automatically selected, at least in 8.1.5.
Richard Huxton wrote:
>
> novnov wrote:
>> I'm sure I didn't do something properly but the point is, as a newbie,
>> none
>> of it is obvious.
>>
>> How
On þri, 2006-11-28 at 12:28 -0700, Scott Ribe wrote:
> >>> where a <> b or (a is null and b is not null) or (a is not null and
> >>> b is null)
> >>
> >> In the absence of IS DISTINCT FROM, I think this has the same semantics:
> >>
> >>where coalesce(a, b) <> coalesce(b, a)
> >
> > sorry, bu
"Edwin Grubbs" <[EMAIL PROTECTED]> writes:
> Under postgres 8.1, the "<<=" comparison yields very slow queries with large
> tables.
<<= isn't optimizable within joins, and really isn't very suited to
btree indexes at all. Sometime somebody should try to build a GiST
opclass that supports network
Wm.A.Stafford wrote:
I'm trying to use a temporary sequence to duplicate the functionality
of the Oracle rownum pseudo-column
as suggested by Scott Marlow in the archives:
http://archives.postgresql.org/pgsql-sql/2005-05/msg00126.php.
The Oracle based application I'm porting to PostgreSQL used
On 11/28/06, Tony Caduto <[EMAIL PROTECTED]> wrote:
Thomas Kellerer wrote:
>
>
> And who cares if my bytecode knows something about Generics as long as
> the application runs at a good speed?
>
I totally agree about generics, nice to have but not really needed.
I dont like generics as much as c
"Wm.A.Stafford" <[EMAIL PROTECTED]> writes:
> ... is there a standard PostgreSQL way to select a
> 'block' of rows from a result set based on row number?
LIMIT/OFFSET might be what you are looking for --- it's certainly far
less klugy than a temporary sequence.
regards, t
Martijn van Oosterhout writes:
> Err, that means copy is just rewriting the executable code in the
> backend of the server, while it's running, which understandably
> crashes.
No, I don't think so. "cp -f" means "unlink the old file and create a
new one", as opposed to plain cp which would overw
On 11/28/06, Tom Lane <[EMAIL PROTECTED]> wrote:
Martijn van Oosterhout writes:
> On Tue, Nov 28, 2006 at 03:23:36PM -0500, Tom Lane wrote:
>> I'd suggest putting together a simple stand-alone test case and filing
>> a bug report against glibc.
> How can glibc do anything about this? dlopen() m
Martijn van Oosterhout writes:
> On Tue, Nov 28, 2006 at 03:23:36PM -0500, Tom Lane wrote:
>> I'd suggest putting together a simple stand-alone test case and filing
>> a bug report against glibc.
> How can glibc do anything about this? dlopen() mmaps the .so into
> memory and the cp overwrites wh
On Tue, Nov 28, 2006 at 03:23:36PM -0500, Tom Lane wrote:
> I'd suggest putting together a simple stand-alone test case and filing
> a bug report against glibc. You probably just need
>
> dlopen(...);
> system("cp -f over the .so file");
> dlsym(...);
How can glibc do anything
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> ok, an update on this. we actually covered up the bug in reducing the
> problem to our test case. our make system used cp -f to overwite the
> .so file in use by postgresql.
With that I can reproduce it --- I think it is a glibc bug. The crash
occu
I'm trying to use a temporary sequence to duplicate the functionality of
the Oracle rownum pseudo-column
as suggested by Scott Marlow in the archives:
http://archives.postgresql.org/pgsql-sql/2005-05/msg00126.php.
The Oracle based application I'm porting to PostgreSQL used rownum to
select th
On Tue, Nov 28, 2006 at 02:38:18PM -0500, Merlin Moncure wrote:
> On 11/28/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> >"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> >> We are getting a backend crash after issueing a load command.
> >
> >No crash from your example here (on Fedora Core 5). What plat
Thomas Kellerer wrote:
And who cares if my bytecode knows something about Generics as long as
the application runs at a good speed?
I totally agree about generics, nice to have but not really needed.
In case not everyone is up to speed about generics, this article is
really good:
http:/
Under postgres 8.1, the "<<=" comparison yields very slow queries with large
tables. I can rewrite the query without the "<<=" operator by generating all
33 possible netmasks (0 through 32) for a given IP. This ugly rewrite runs
about 12 times faster (6 seconds versus 0.5 seconds). Be aware that E
On þri, 2006-11-28 at 19:23 +0200, Andrus wrote:
> Richard,
>
> I really do'nt want to open separate port for backup only.
> Pelase, can you recomment a solution which uses port 5432 owned by Postgres
I do not want to advice you to do things that might be
counter your company's security policies
Rich Shepard wrote:
On Tue, 28 Nov 2006, Tony Caduto wrote:
The reason there is no highly productive IDE for Linux/Mac with a nice
forms designer and robust data binding is because in the grand scheme of
things there are not a lot of desktop users for anything other than
win32. Sure there are
Andrus wrote on 28.11.2006 18:17:
5. Java is not LGPL and does not support Generic at bytecode level
I have heard this "Java is not open source" over and over again.
What's the issue with wanting the language to be open source? Where is the
problem with using Java from a license perspective? Yo
On 11/28/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> We are getting a backend crash after issueing a load command.
No crash from your example here (on Fedora Core 5). What platform and
gcc are you using exactly? Can you provide a stack trace from the
>>> where a <> b or (a is null and b is not null) or (a is not null and
>>> b is null)
>>
>> In the absence of IS DISTINCT FROM, I think this has the same semantics:
>>
>>where coalesce(a, b) <> coalesce(b, a)
>
> sorry, but no.
So it would have to be where coalesce(a, b, 0) <> coalesce(b,
On Tue, 28 Nov 2006, Merlin Moncure wrote:
For a general purpose language, lately I've been taking a really good look
at 'D', which looks to be an amazing language. Has anybody tried to hook
up postgresql to D?
No, I haven't. But, if you want a cross-platform language and GUI toolkit,
consi
On Nov 28, 2006, at 11:11 AM, Andrus wrote:
1. My database size seems to be appox 1 GB and download speed is
approx 600
kb/s. Your solution requires 4.5 hours download time
since 1 GB of data must be downloaded.
If you're running pg_dump on a remote host, you're transferring the
data ove
On Tue, 28 Nov 2006, Tony Caduto wrote:
The reason there is no highly productive IDE for Linux/Mac with a nice
forms designer and robust data binding is because in the grand scheme of
things there are not a lot of desktop users for anything other than win32.
Sure there are lots of geeks that us
> --- Original Message ---
> From: Richard Huxton
> To: novnov <[EMAIL PROTECTED]>
> Sent: 28/11/06, 18:56:37
> Subject: Re: [GENERAL] Editing contrib modules which are loaded by default?
>
> Because I just don't believe that
> the installer doesn't let you turn the cube contrib off.
John DeSoi wrote:
As I mentioned previously, XUL is worth a look for cross platform
applications. I would call FireFox, Mozilla, and Thunderbird serious
applications. And check out Komodo, an excellent cross platform
development environment built on this framework.
They are serious applica
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> Not sure but using a binary cursor might improve things.
Why not use COPY protocol?
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
[EMAIL PROTECTED] (Bill Kurland) writes:
> Chris Browne wrote:
>> [EMAIL PROTECTED] (Tom Lane) writes:
>>
>>> Bill Kurland <[EMAIL PROTECTED]> writes:
>>>
I did a google search on AIX + getaddrinfo and found
http://lists.samba.org/archive/rsync/2002-April/002063.html
In that context
On Tue, 2006-11-28 at 13:52 -0500, John DeSoi wrote:
> On Nov 28, 2006, at 12:17 PM, Andrus wrote:
>
> > Only MONO/WinForms is a way to go in any serious application.
>
>
> Funny. Did you read the original post? The poster wanted a *cross-
> platform* GUI and his primary development environmen
Andrus wrote:
Richard,
Use scp. Open port 22 and allow only connections from the backup machine
with a specified user (e.g. "pgbackup").
Alternatively, you might try dumping in a text-format and using rsync to
transfer changes.
I really do'nt want to open separate port for backup only.
Pel
where a <> b or (a is null and b is not null) or (a is not null
and b is null)
In the absence of IS DISTINCT FROM, I think this has the same
semantics:
where coalesce(a, b) <> coalesce(b, a)
sorry, but no.
Argh, my expression is just nonsense - I was thinking of something like:
co
On 11/28/06, Olexandr Melnyk <[EMAIL PROTECTED]> wrote:
2006/11/28, Tony Caduto <[EMAIL PROTECTED]>:
> Mono 1.2 only fully supports .net 1.1 (for winforms)
Yes. But it already supports most of the .NET 2.0 features (not talking of
WinForms here) including the ones metioned above and has a C# 2.0
novnov wrote:
I'm sure I didn't do something properly but the point is, as a newbie, none
of it is obvious.
However I'm going to have to try again, as the setup for pgsql 8.1 does not
seem to have a way to turn off the cube contrib modules. They are not listed
anywhere in the setup console.
W
On 28 Nov 2006 at 10:01, novnov wrote:
> I'm sure I didn't do something properly but the point is, as a newbie,
> none of it is obvious.
The documentation that comes with PostgreSQL head-and-shoulders above
anything that comes with many commercial products. If you're going to
work woth Postgre
On Nov 28, 2006, at 12:17 PM, Andrus wrote:
Only MONO/WinForms is a way to go in any serious application.
Funny. Did you read the original post? The poster wanted a *cross-
platform* GUI and his primary development environment was OS X. Mono
might run on a Mac after you install thousands
On Tue, Nov 28, 2006 at 07:34:56PM +0200, Andrus wrote:
> This id good idea but it forces to use Postgres protocol for downloading.
Why, of course.
> This protocol has some timeouts which are too small for large file download.
For "sane" values of "large" I doubt this is true. A field
in PG can s
On Tue, Nov 28, 2006 at 07:23:44PM +0200, Andrus wrote:
> Pelase, can you recomment a solution which uses port 5432 owned by Postgres
If you think you know your usage pattern:
Have cron stop PostgreSQL at, say, 2am.
Have cron start ssh on port 5432 at 2:05am if PG is down.
Have cron shutdown s
On Tue, 2006-11-28 at 19:34 +0200, Andrus wrote:
> > You could use an *un*trusted procedural language to create a
> > function to binary-read the backup from disk and return it
> > as a bytea field. Not sure how efficient that is, though.
> >
> > You could then simply do
> >
> > select get_backup()
So i've been given the task of designing a data warehouse in
either Postgresql or Mysql for our clickstream data for our sites. I
started with Mysql but the joins in Mysql are just way too slow
compared to Postgresql when playing with star schemas. I can't say
which sites i'm working on, but we g
I'm sure I didn't do something properly but the point is, as a newbie, none
of it is obvious.
However I'm going to have to try again, as the setup for pgsql 8.1 does not
seem to have a way to turn off the cube contrib modules. They are not listed
anywhere in the setup console.
Or I will try to
Tom Lane wrote:
> Can anyone else confirm the behavior of getaddrinfo wanting port 5432
> to be listed in /etc/services? If this is real, we ought to have
> something about it in FAQ_AIX.
I can compile (64 bit) and run the following code without problem:
#include
#include
#include
int main(i
On Tue, 2006-11-28 at 09:38 -0800, novnov wrote:
> I imagine that there is a step in the windows install that allows one to
> select contrib modules. I don't recall. I didn't add these contrib modules,
> so they must be included by default, which frankly seems pretty dumb.
>
> I've tried to follow
I don't see where doing the backup directly to another computer increases
your safety margin, it may even lower it due to the increased potential for
network issues messing up the backup cycle. Do it locally then SCP the
completed (and compressed) file to another computer, which is what I do.
(In
I imagine that there is a step in the windows install that allows one to
select contrib modules. I don't recall. I didn't add these contrib modules,
so they must be included by default, which frankly seems pretty dumb.
I've tried to follow the instructions on the pgsql site for replacing
template
Richard,
> Use scp. Open port 22 and allow only connections from the backup machine
> with a specified user (e.g. "pgbackup").
>
> Alternatively, you might try dumping in a text-format and using rsync to
> transfer changes.
I really do'nt want to open separate port for backup only.
Pelase, can
> You could use an *un*trusted procedural language to create a
> function to binary-read the backup from disk and return it
> as a bytea field. Not sure how efficient that is, though.
>
> You could then simply do
>
> select get_backup();
>
> If you allow for parameters you could make it return cert
>
> Conclusion:
>
> Only MONO/WinForms is a way to go in any serious application.
Py/QT? Py/GTK?
Joshua D. Drake
>
>
> Andrus.
>
>
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>
On Tue, 2006-11-28 at 17:31 +, Tomi N/A wrote:
> 2006/11/28, Andrus <[EMAIL PROTECTED]>:
>
> > Only MONO/WinForms is a way to go in any serious application.
>
> Mono needs to show a lot more than beagle and f-spot to be even
> considered interesting, let alone a platform to base industrial
>
2006/11/28, Tony Caduto <[EMAIL PROTECTED]>:
Mono 1.2 only fully supports .net 1.1 (for winforms)
Yes. But it already supports most of the .NET 2.0 features (not talking of
WinForms here) including the ones metioned above and has a C# 2.0 compiler.
What kind of problems have you seen with the
2006/11/28, Andrus <[EMAIL PROTECTED]>:
Only MONO/WinForms is a way to go in any serious application.
Mono needs to show a lot more than beagle and f-spot to be even
considered interesting, let alone a platform to base industrial
strength applications on.
As long as that doesn't radically cha
>So my advice goes towards Mono/Gtk#. There is a bunch of programming
>languages for Mono/.NET to choose from, so choosing one of them mostly
>depends on your taste.
Here is some information missing from this thread:
1. Gtk# does not support data binding required for database application. It
Chris Browne wrote:
[EMAIL PROTECTED] (Tom Lane) writes:
Bill Kurland <[EMAIL PROTECTED]> writes:
I did a google search on AIX + getaddrinfo and found
http://lists.samba.org/archive/rsync/2002-April/002063.html
In that context the author says that adding the port number in
etc/services
"Joshua D. Drake" wrote:
>
> That's it, in a nut shell. There is no argument there. That is why you
> don't use artificial keys. That said... pretty much every table I create
> will have an artificial key... because it makes managing data easy. An
> example (to reuse the simple example):
>
> us
I am trying to restore from a pg_dump. Pg_restore is doing some
strange behaviour.
If I open a CMD shell console and execute pg_restore, nothing is
showed. If I try to do a "with sense" pg_restore, nothing is showed in
spite of I have put --verbose option.
This is my complete command:
pg_resto
Terry Yapt wrote:
> I am trying to restore from a pg_dump. Pg_restore is doing some
> strange behaviour.
>
> If I open a CMD shell console and execute pg_restore, nothing is
> showed. If I try to do a "with sense" pg_restore, nothing is showed
> in spite of I have put --verbose option.
>
> Thi
I'm not really sure whether Wombats are any good.
The picture on Wikipedia looks like a horrid little Pig.
Quite Obscene.
Just not English.
274
--
Posted via a free Usenet account from http://www.teranews.com
---(end of broadcast)---
TIP 4: H
Can someone tell me whether Wombats live only in Australia,
or also on other continents?
Apart from zoos, of course.
We all know that Wombats are to be found in Zoos.
274
--
Posted via a free Usenet account from http://www.teranews.com
---(end of broadcast)--
On Tue, Nov 28, 2006 at 11:00:35AM -0500, Stephen Harris wrote:
> This is probably a silly question, but are the database files binary portable?
> eg could I take datafiles from a Sparc and copy them to an Intel machine,
> or would the endianness differences kill me?
No.
It may not even be compat
On Tue, Nov 28, 2006 at 03:33:54PM +0200, Olexandr Melnyk wrote:
> >This would mean something like an index spreading over more then one
> >table in the end, or did I miss something ?
>
> Yes. But that is hardly implementable.
Actually, an index over multiple tables is not really the hard part.
I
On Tue, Nov 28, 2006 at 11:11:26AM -0500, Stephen Harris wrote:
> The solution, obviously, is LDFLAGS=-Wl,-R/opt/mystuff/lib ./configure
> and now everything configures and builds cleanly, but it might be nice
> for that to be automatic.
RPATH is evil. If you're going to install libraries in n
Stephen Harris <[EMAIL PROTECTED]> writes:
> This is probably a silly question, but are the database files binary portable?
No.
regards, tom lane
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Tue, Nov 28, 2006 at 03:29:44PM +0200, Andrus wrote:
> > If you've got excess CPU capacity at night, I wonder if -Z1 or -Z2
> > would speed the backup since it reduces the amount of data written
> > to disk.
>
> Where to find study which pg_dump compares backup speed and backup size by
> using
Andrus wrote:
So I think that 4.5 hours which requires to create backup is because pg_dump
download the whole database (1 GB) in uncompressed format over slow
internet connection.
Compression level does not affect to this almost at all.
Might well be latency issues too.
I think I can create
On Tue, Nov 28, 2006 at 06:01:43PM +0200, Andrus wrote:
> 5. Server has *only* 5432 port open.
>
> pg_read_file() can read only text files and is restricted only to
> superusers.
>
> How to add a function pg_read_backup() to Postgres which creates and
> returns backup file with download speed
Stephen Harris wrote:
This is probably a silly question, but are the database files binary portable?
No
eg could I take datafiles from a Sparc and copy them to an Intel machine,
or would the endianness differences kill me?
Yes
How about cross OS (eg from Linux Intel to Windows XP, or from
> $ ssh 81.50.12.18 "pg_dump -Z0 -Fc -ibv -U myuser mydb" | gzip -9
Alexander,
1. My database size seems to be appox 1 GB and download speed is approx 600
kb/s. Your solution requires 4.5 hours download time
since 1 GB of data must be downloaded.
2. I have only 5432 port open to public interne
I didn't see this mentioned in the INSTALL or doc/ directory, so...
I have versions of SSL libraries in my own directories and so used
a command line such as:
./configure --prefix=/local/apps/postgres/8.2.rc1.0 \
--exec-prefix=/local/apps/postgres/8.2.rc1.0/linux \
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 28 Nov 2006, at 13:33, Olexandr Melnyk wrote:
Looks like I've missed your mail, so a late reply.
2006/11/11, Lars Heidieker <[EMAIL PROTECTED]>:
> > > While I agree in principle that such a thing should be
> > > able to be done, it simply isn
Olexandr Melnyk wrote:
Mono/.NET is definately worth the consideration. However, I'd advice
you not to go with Turbo C#, as it only supports .NET 1.*, so you
won't be able to use such goodies as: generics and nullable types,
which are quite handy, especially for the database-oriented applica
Thomas Kellerer wrote:
On 27.11.2006 17:36 Tony Caduto wrote:
The closest to Delphi in a cross platform system is NetBeans and even
with their form designer it's still tedious working with databases
compared to Delphi.
What about Lazarus? It claims to be cross-platform, but I don't know
how
[EMAIL PROTECTED] (Tom Lane) writes:
> Bill Kurland <[EMAIL PROTECTED]> writes:
>> I did a google search on AIX + getaddrinfo and found
>> http://lists.samba.org/archive/rsync/2002-April/002063.html
>> In that context the author says that adding the port number in
>> etc/services solved his proble
> The weekly backup of the larger of the two databases produces a file that
> is about 20GB and takes about an hour and 15 minutes. I then compress it
> down to about 4 GB, which takes another hour. However, because that's a
> separate task, it doesn't impact the database server as much. (I su
This is probably a silly question, but are the database files binary portable?
eg could I take datafiles from a Sparc and copy them to an Intel machine,
or would the endianness differences kill me?
I expect the answer to be "funny man! Of course not!" for reasons of speed
(native interger handlin
On þri, 2006-11-28 at 09:42 -0500, John D. Burger wrote:
> Scott Ribe wrote:
>
> > where a <> b or (a is null and b is not null) or (a is not null and
> > b is null)
>
> In the absence of IS DISTINCT FROM, I think this has the same semantics:
>
>where coalesce(a, b) <> coalesce(b, a)
sorr
On Nov 28, 2006, at 8:40 AM, Jakub Ouhrabka wrote:
There are 4G of RAM and 4G swap.
and what is the per-process resource limit imposed by your OS?
Just because your box has that much RAM doesn't mean your process is
allowed to use it.
smime.p7s
Description: S/MIME cryptographic signatu
On 11/28/06, Andrus <[EMAIL PROTECTED]> wrote:
My goal is to create ERP system which creates backups without any
attendance.
I don'nt know how to automate this 100% and havent found any such sample.
Depending on what you plan to do with the backups (like create a fallover
server), I don't kno
Scott Ribe wrote:
where a <> b or (a is null and b is not null) or (a is not null and
b is null)
In the absence of IS DISTINCT FROM, I think this has the same semantics:
where coalesce(a, b) <> coalesce(b, a)
although it's not as concise as one might wish.
- John D. Burger
MITRE
-
On Mon, Nov 27, 2006 at 05:24:31PM -0600, Jim Nasby wrote:
> In any case, like Oracle, PostgreSQL does not index NULL values (at
> least not in btree).
Actually, PostgreSQL does store NULL values in an index, otherwise you
could never use them for full index scans (think multicolumn indexes).
Yo
> If you've got excess CPU capacity at night, I wonder if -Z1 or -Z2
> would speed the backup since it reduces the amount of data written
> to disk.
Where to find study which pg_dump compares backup speed and backup size by
using various -Z options ?
I'm wondering by -Z9 increases backup speed.
> You might try using online backups. By following the steps in this
> document:
>
> http://www.postgresql.org/docs/8.1/static/backup-online.html
>
> you can back up the data at the speed of your filesystem. There's no way
> to make it faster than that.
PITR config is complicated. A lot of manual
Thanks for the responses!
One thing I've forgotten: it's not reproducible. I can issue vacuum
command manually without any problems few minutes/seconds after seeing
the error message "out of memory" in the server log.
I also can't find any corrupted rows manually.
And for the listen/notify p
1 - 100 of 112 matches
Mail list logo
