What pg_dump backup modes do people usually use for a backup of an
entire database cluster? I usually use plaintext and pipe it through
gzip, however, that doesn't allow you to restore single objects from a
complete backup.
Is there a way to back up the entire cluster using the "t" or "c" output
m
Samik Raychaudhuri <[EMAIL PROTECTED]> writes:
> ... What I wanted is a no-trace (or minimal trace), no-admin required
> kind of installation (I won't be able to create a non-admin user in the
> comp), which, when I am done, I can just delete the installation
> directory and will be clear.
Post
Jonathan Tse <[EMAIL PROTECTED]> writes:
> I just downloaded 8.03 source and try to compile the contrib module
> intarray by following the instruction in readme. However, I got the
> following error:
You need to run "configure" at the top of the distribution tree first.
Be sure to give confi
Le 2005 10 02 14:36, David Fetter a ecrit:
> On Sat, Oct 01, 2005 at 09:37:49PM -0700, Cosmopo wrote:
> > Hello,
> >
> > I was using many years ago Sybase that was able then to query
> > several tables that could be located in more than one database... I
> > know that Postgresql did not at the time
On Sun, Oct 02, 2005 at 11:20:38PM -0400, Marc Andre Paquin wrote:
> Le 2005 10 02 14:36, David Fetter a ecrit:
> > On Sat, Oct 01, 2005 at 09:37:49PM -0700, Cosmopo wrote:
> > > Hello,
> > >
> > > I was using many years ago Sybase that was able then to query
> > > several tables that could be loca
Hi list,
I just downloaded 8.03 source and try to compile the contrib module
intarray by following the instruction in readme. However, I got the
following error:
$ gmake
Makefile:15: ../../src/Makefile.global: No such file or directory
Makefile:16: /contrib/contrib-global.mk: No such file
Hi,
Sorry for being so abtuse; my 9 year old has been helping me with my
work today. :)
The hamming distance between two bit vectors can also be found as the
sum of distances between sub-vectors. Let's assume you're looking
for all vectors less than d bits away from a search vector, and we'll
d
On 10/2/05 4:13 PM, "Martijn van Oosterhout" wrote:
> Problem is, the space is also the word seperator. So if you have a
> space seperated list of words (ie normal for make), names with spaces
> are a pain.
>
> It occurred to me that you might be able to replace the spaces in the
> paths with qu
Wes <[EMAIL PROTECTED]> writes:
> On 10/2/05 7:48 AM, "William ZHANG" <[EMAIL PROTECTED]> wrote:
>> Yes, the Makefiles cannot deal with spaces correctly.
>> Seems we should avoid use the `complicated' path.
> Such paths are normal on systems with a GUI interface. They are not out of
> the ordinar
Hi,
Try breaking the vector into 4 bigint columns and building a multi-column
index, with index columns going from the most evenly distributed to the
least. Depending on the distribution of your data, you may only need 2
or 3 columns in the index. If you can cluster the table in that order,
it
Any one of the binary packages should allow that ... if you are looking at
Windows, check out the pginstaller project on http://www.pgfoundry.org ...
On Sun, 2 Oct 2005, Samik Raychaudhuri wrote:
Hello Group:
Is there any 'portable' version of PostgreSQL for Windows? By 'portable' I
mean,
Hrm, I don't understand. Can you give me an example with some
reasonably sized vectors?
On Oct 2, 2005, at 10:59 AM, Todd A. Cook wrote:
Hi,
Try breaking the vector into 4 bigint columns and building a multi-
column
index, with index columns going from the most evenly distributed to
the
l
Thanks for your reply Marc. Yes I am looking at Windows and I was
looking at pginstaller project before emailing. If my understanding is
correct, the project aims developing a Win installer for normal windows
program installation, with registry entries for future uninstallation
etc. What I want
On Sat, Oct 01, 2005 at 09:37:49PM -0700, Cosmopo wrote:
> Hello,
>
> I was using many years ago Sybase that was able then to query
> several tables that could be located in more than one database... I
> know that Postgresql did not at the time have this capability.
>
> Does the new version 8.0.x
On Sun, Oct 02, 2005 at 12:15:05PM -0500, Wes wrote:
> On 10/2/05 7:48 AM, "William ZHANG" <[EMAIL PROTECTED]> wrote:
>
> > Yes, the Makefiles cannot deal with spaces correctly.
> > Seems we should avoid use the `complicated' path.
>
> Such paths are normal on systems with a GUI interface. They
Hi,
It may be that I don't understand your problem. :)
Are you searching the table for the closest vector? If so, is
"closeness" defined only as the number of bits that are different?
Or, do you need to know which bits as well?
-- todd
Ben wrote:
Hrm, I don't understand. Can you give me an e
Just the number of bits, not which ones. Basically, the hamming
distance.
On Oct 2, 2005, at 11:44 AM, Todd A. Cook wrote:
Hi,
It may be that I don't understand your problem. :)
Are you searching the table for the closest vector? If so, is
"closeness" defined only as the number of bits tha
> Hello Group:
>
> Is there any 'portable' version of PostgreSQL for Windows? By
> 'portable'
> I mean, I can just unzip files, run the initdb and then run
> the postmaster and I get a temporary database server running
> on port 5432 and accepting connections?
Um, yes, this should go with any
Samik Raychaudhuri <[EMAIL PROTECTED]> schrieb:
> Hello Group:
>
> Is there any 'portable' version of PostgreSQL for Windows? By 'portable' I
> mean, I can just unzip files, run the initdb and then run the postmaster
> and I get a temporary database server running on port 5432 and accepting
>
Ben wrote:
Just the number of bits, not which ones. Basically, the hamming distance.
I see. Could you pre-compute the bit counts for the vectors in the table?
You could count the bits in the search vector as Martijn suggested, and then
do a lookup based on the count.
-- todd
Yeah, I thought about this, but damn my 3-dimensional mind, I just
can't convince myself this will work for 256 dimensions. :) Or
rather, I can see how it could, *given* good placements of the grid
points to snap each vector to. Unfortunately, I don't know enough
theory to know what good pl
Sure, but unless I can figure out some way to choose a small number
of vectors, I'm left with computing the full N^2 set. Given that I'm
shooting for N to be 4 million or larger, that's a lot of data to
store.
On Oct 2, 2005, at 12:14 PM, Todd A. Cook wrote:
Ben wrote:
Just the numbe
I found the binary-no-install for 8.0.3 sometime back. Will test it out.
Thanks for your help.
-Samik
On 10/2/2005 3:31 PM, Magnus Hagander wrote:
Hello Group:
Is there any 'portable' version of PostgreSQL for Windows? By
'portable'
I mean, I can just unzip files, run the initdb and then run
On Sun, Oct 02, 2005 at 10:17:10AM -0700, Ben wrote:
> Yeah, I thought about this, but damn my 3-dimensional mind, I just
> can't convince myself this will work for 256 dimensions. :) Or
> rather, I can see how it could, *given* good placements of the grid
> points to snap each vector to. Unf
On 10/2/05 7:48 AM, "William ZHANG" <[EMAIL PROTECTED]> wrote:
> Yes, the Makefiles cannot deal with spaces correctly.
> Seems we should avoid use the `complicated' path.
Such paths are normal on systems with a GUI interface. They are not out of
the ordinary nor complicated.
Wes
Hrm, I'll think about it. Thanks!
On Oct 2, 2005, at 12:50 PM, Martijn van Oosterhout wrote:
On Sun, Oct 02, 2005 at 10:17:10AM -0700, Ben wrote:
Yeah, I thought about this, but damn my 3-dimensional mind, I just
can't convince myself this will work for 256 dimensions. :) Or
rather, I can see
Hi all,
I am not expert in PHP, so my assumption may not correct
Can we solve this problem by increasing the "max_execution_time"
value at php.ini file?
--Nirmalya
--- Ben-Nes Yonatan <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I sent the following email to the php mailing list also but may
On Sun, Oct 02, 2005 at 08:28:53AM -0700, Ben wrote:
> Yes, that's the straightforward way to do it. But given that my
> vectors are 256 bits in length, and that I'm going to eventually have
> about 4 million of them to search through, I was hoping greater minds
> than mine had figured out ho
Hello Group:
Is there any 'portable' version of PostgreSQL for Windows? By 'portable'
I mean, I can just unzip files, run the initdb and then run the
postmaster and I get a temporary database server running on port 5432
and accepting connections?
Thanks.
-Samik
---(e
--- Reid Thompson <[EMAIL PROTECTED]> wrote:
> I've written a simple getting started, 'PostgreSQL and Dev-Cpp
> Dev-C++
> on Windows example'. I was wondering if this would be pertinent to
> post
> to pgsql-general or one of the other PG lists?
>
If you are asking because of the existence of
Steve Manes <[EMAIL PROTECTED]> writes:
> Questions: is there a hard limit to the number of schemas you could have
> in a database?
No.
> Are there any caveats/pitfalls/pitbulls to having a
> large number of duplicate schemas in a database?
If that also implies a large number of tables, you mi
Yes, that's the straightforward way to do it. But given that my
vectors are 256 bits in length, and that I'm going to eventually have
about 4 million of them to search through, I was hoping greater minds
than mine had figured out how to do it faster, or how compute some
kind of indexing
Ben-Nes Yonatan <[EMAIL PROTECTED]> writes:
> I seem to have a problem to run the code when there are single queries
> which take long times (like 5 hours for an update query), from the log
> of the database I received the following code:
> 2005-09-30 17:12:13 IDT postgres : LOG: 08006: could not
Hello All,
I have a dump file using phpPgAdmin in sql format.
I took this file and then using PgAdminIII ran the sql script on a Windows XP machine.
Though i don't see any errors i can't see the database with tables being created!!!
This approach had worked in the past for me on a Win 2000 box.
Wh
Am Sonntag, den 02.10.2005, 16:39 +0200 schrieb Ben-Nes Yonatan:
> Martijn van Oosterhout wrote:
...
> Well this is not the case (sadly.. :)) cause the process is running at
> the server without any browser interface.
Use the web as trigger only and a persistent long running process
to read the j
Questions: is there a hard limit to the number of schemas you could have
in a database? Are there any caveats/pitfalls/pitbulls to having a
large number of duplicate schemas in a database?
---(end of broadcast)---
TIP 6: explain analyze is your
Martijn van Oosterhout wrote:
On Sun, Oct 02, 2005 at 12:07:18PM +0200, Ben-Nes Yonatan wrote:
I wrote a php script which is running very long queries (hours) on a
database.
I seem to have a problem to run the code when there are single queries
which take long times (like 5 hours for an upda
Yes, the Makefiles cannot deal with spaces correctly.
Seems we should avoid use the `complicated' path.
"Wes" <[EMAIL PROTECTED]> wrote
> System: Mac OS X 10.4.2
> PostgreSQL: 8.1 b2
>
> Running 'make check', I get the following failure:
>
> rm -rf ./testtablespace
> mkdir ./testtablespace
> /bin
Sybase and Microsoft SQL Server are somewhat silimar on
the concept `database'. They both support queries across
multiple databases. But pgsql's database is different,
I think you can use pgsql's schemas to cope with problem.
Regards, William ZHANG
"Cosmopo" <[EMAIL PROTECTED]> wrote
> Hello,
>
Cosmopo <[EMAIL PROTECTED]> schrieb:
> Does the new version 8.0.x ofter this feature? We need to create
> several databases based on our customer's specs... but we need our own
> customer, permission, history, etc database. We want to be able to
> query 2 database that would have share customer's I
On Sun, Oct 02, 2005 at 12:07:18PM +0200, Ben-Nes Yonatan wrote:
> I wrote a php script which is running very long queries (hours) on a
> database.
> I seem to have a problem to run the code when there are single queries
> which take long times (like 5 hours for an update query), from the log
> of
On Sun, Oct 02, 2005 at 11:37:10AM +0200, Zlatko Mati? wrote:
> There are some columns in my tables that I should change from varchar to
> text, in order to have enough space for long textual commentaries.
> Before I do that, I would like to know is there any restriction regarding
> text type in
On Sat, Oct 01, 2005 at 07:12:13PM -0700, Ben wrote:
> I'm looking for a quick way to find the number of bits that are
> different between two bitmasks of the same size. I'll be doing this a
> lot, so speed is desirable some kind of indexing would be even
> better. It seems like this prob
Jim C. Nasby wrote:
On Tue, Sep 27, 2005 at 01:34:37PM +0200, Yonatan Ben-Nes wrote:
Based on http://lnk.nu/developer.postgresql.org/44b.c, line 1478 on,
there's not a lot that happens during the ALTER TABLE. Likewise DROP
(line 517) doesn't do much either. So basically, anything trying to
a
I've written a simple getting started, 'PostgreSQL and Dev-Cpp Dev-C++
on Windows example'. I was wondering if this would be pertinent to post
to pgsql-general or one of the other PG lists?
reid
---(end of broadcast)---
TIP 3: Have you checked o
Hi all,
I sent the following email to the php mailing list also but maybe this
is a more appropriate mailing list.
I wrote a php script which is running very long queries (hours) on a
database.
I seem to have a problem to run the code when there are single queries
which take long times (like 5
Hello,
I was using many years ago Sybase that was able then to query several
tables that could be located in more than one database... I know that
Postgresql did not at the time have this capability.
Does the new version 8.0.x ofter this feature? We need to create
several databases based on our c
Hello.
There are some columns in my tables that I should
change from varchar to text, in order to have enough space for long textual
commentaries.
Before I do that, I would like to know is there any
restriction regarding text type in comparison to varchar type?
Especially concerning trigge
thanks.
- Original Message -
From: "Magnus Hagander" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>;
Sent: Friday, September 30, 2005 12:58 PM
Subject: RE: [GENERAL] installing several PostgreSQL instances on Windows
Hello.
Is it possible to install several completely
Hi all,
I sent the following email to the php mailing list also but maybe this
is a more appropriate mailing list.
I wrote a php script which is running very long queries (hours) on a
database.
I seem to have a problem to run the code when there are single queries
which take long times (like 5 h
50 matches
Mail list logo
