On 06.02.2008, at 19:41, Andrej Ricnik-Bay wrote:
And a more generic version :}
Thanks for that!
I had solved my problem as I saw that actually importing all database
from the dump file was faster than compressing the dump file (on a 4
core Woodcrest). So it wasn't that big of a deal that
On 04.02.2008, at 18:00, Gurjeet Singh wrote:
I understand it all needs a little bit of 'vi' wizardry, (or
whichever editor you are using). Also, as with all open-source
suggestions, do not rely on this procedure until you understand what
and how it does what it does.
Sure, the only probl
On 04.02.2008, at 10:41, Gurjeet Singh wrote:
What was the output format option used (-f option) ? Was it the
plain-text (SQL) or custom format?
I cannot see a -f option on pg_dumpall. This is the command:
pg_dumpall > `date "+%y-%m-%d"`.sql
I just want to use an older file from a dump to r
Hi.
Is it possible to reload only specific databases from a file created
by pg_dumpall?
Thanks,
cug
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column'
On 09.01.2008, at 13:51, Martin wrote:
I've been working with FrontBase a lot lately and I wouldn't say
anything about it qualifies as "incredibly easy" and reliable it
is not.
We had never ever any reliability issues with FrontBase as long as
didn't try to insert garbage. It really doesn't
On 09.01.2008, at 13:51, Martin wrote:
I've been working with FrontBase a lot lately and I wouldn't say
anything about it qualifies as "incredibly easy" and reliable it
is not.
We had never ever any reliability issues with FrontBase as long as
didn't try to insert garbage. It really doesn't
On 09.01.2008, at 09:05, Andrew Sullivan wrote:
Easy multi-master clustering with just two machines.
To my knowledge, _nobody_ actually offers that.
As I said: FrontBase is offering that.
cug
--
http://www.event-s.net
---(end of broadcast)-
On 09.01.2008, at 00:14, Ow Mun Heng wrote:
Like, I have a situation where I need multi-master just for
availability. Two small servers are good enough for that. But
unfortunately with PostgreSQL the whole setup is a major pain in
the ...
Isn't that the reason they hire DB admins and not t
On 09.01.2008, at 00:08, Joshua D. Drake wrote:
Did you even bother to read the page?
Actually I tried but typed it in the browser and it resolved directly
to continuent.com (which I have as a bookmark) and I wasn't aware of
the Sequoia stuff anymore and combined Contiuent with uni/cluster
On 08.01.2008, at 23:40, Joshua D. Drake wrote:
There are OS level things you can do here.
They are normally not really easier and, more important, I don't have
them on my deployment environment.
http://www.continuent.org/HomePage
When I'm talking about two cheap machines you recommend
On 08.01.2008, at 23:20, Joshua D. Drake wrote:
That isn't really an extensibility argument.
I was thinking about that too - for me, it still is just an
outstanding issue with PostgreSQL. It is incredibly scalable on one
machine but it totally sucks when you want more, but not much more.
On 08.01.2008, at 17:36, Joshua D. Drake wrote:
2. What types of extensibility (possibly already available in
other DBMSs) are currently missing in PostgreSQL?
None that I am aware of.
Easy multi-master clustering with just two machines.
cug
--
http://www.event-s.net
---
On 01.12.2007, at 09:35, Ragnar Heil wrote:
WHich solution are you using now, Guido?
For the one installation we needed multi-master, we have FrontBase
running.
PostgreSQL multi-master just wasn't "right" for us. Too much hardware
needed to get real redundancy, the setup is too complex a
On 30.11.2007, at 12:50, Shane Ambler wrote:
I project where the "latest news" page shows the newest entry from
March 2005 and the install talks only about PostgreSQL 8.0 isn't
really inspiring confidence ...
Although they aren't the fastest with releases, they really aren't
as bad as tha
On 30.11.2007, at 04:48, Wolfgang Keller wrote:
LSI drivers are not available for MacOS X on PowerMacs? Ouch.
The problem is that they suck as they can't to channel bundling for
higher trough-put to a single disk array.
[not your comment, but referred there]
and Mac OS X, PostgreSQL has e
On 30.11.2007, at 02:34, Usama Dar wrote:
Have you looked at pgCluster
I project where the "latest news" page shows the newest entry from
March 2005 and the install talks only about PostgreSQL 8.0 isn't
really inspiring confidence ...
Continuent is very active, but it limits the servers
On 29.11.2007, at 12:30, Martin wrote:
I am looking at porting a web application from FrontBase to
Postgresql. If anybody has some tips on how to deal with
this, I'd appreciate hearing him. Thanks.
If it is WebObjects, you can contact me off-list. I've done that for
some of our apps. It's no
On 10.08.2007, at 06:58, .ep wrote:
Hi, what if I need to do a count with a WHERE condition? E.g.,
SELECT count(*) from customers where cust_id = 'georgebush' and
created_on > current_date - interval '1 week' ;
Can I get the info about this from somewhere in the pg system tables
as well? Queri
On 07.07.2007, at 06:16, Gabriele wrote:
Let's have a server which feed data to multiple slaves, usually using
direct online connections. Now, we may want to allow those client to
sync the data to a local replica, work offline and then resync the
data back to the server. Which is the easiest way
On 05.04.2007, at 09:09, Scott Ribe wrote:
Yes. You can now edit /etc/sysctl.conf and nothing else is required. I
learned this ~10.4.8, so I don't know when it actually happened.
Okay, that's good. They had the wrong order of commands before, so
that the values in /etc/rc were used and not t
On 04.04.2007, at 16:55, Jamie Deppeler wrote:
Is this a safe setting for g5 1gig ram Os 10.4.9
sysctl -w kern.sysv.shmmax=167772160
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=65536
Why shouldn't it be safe?
cug
---
On 03.04.2007, at 23:00, Jamie Deppeler wrote:
Is it possible to set shared memory settings on the fly in OS X
like you can in Linux e.g. sysctl -w kernel.shmmax=134217728
If this wasn't changed recently - no you can't.
If you use /etc/sysctl.conf make sure it is loaded in /etc/rc before
t
On 12.03.2007, at 22:46, Tom Lane wrote:
Most of us stopped reading about the place where they explained
that (a) they did zero tuning on each database, and (b) they were
comparing myisam to transactional engines.
What I don't like about things like that, is that some morons throw
something
On 22.02.2007, at 16:03, Ted Byers wrote:
One of my problems with database development is how to construct
analogously strong test cases in order to prove the code correct.
With tests you can't prove that your code is correct. You can only
show that your code works with the test cases. Ther
On 22.02.2007, at 15:56, Jim Nasby wrote:
and "surrogate key fields should be named 'id'" (I *much* prefer
the form "object_id", ie: user_id, used *everywhere*, including the
user table (in that example)).
Fortunately, with rails extensibility it shouldn't be hard to
change those default be
Am 19.02.2007 um 17:49 schrieb Jan Wieck:
Oh, this one wasn't about raw speed of trivial single table
statements like all the others?
No, it wasn't. They also tested the insert performance of a system
without foreign keys and without transactions (MySQL MyISAM) against
systems with forei
Am 15.02.2007 um 13:05 schrieb Alexander Elgert:
Nice, but it would be interesting which storage engine was used for
mysql - ok, default is MyIsam.
They used MyISAM as it is described late in the paper.
cug
---(end of broadcast)---
TIP 4: Have
Am 15.02.2007 um 11:21 schrieb Marc Evans:
http://us.devloop.org.uk/
These *peeep* [deleted] compared MySQL with MyISAM to ACID
compliant databases. So why not compare an F-15 to 747? What? Apples
and Oranges? So what? You can compare anything you want, right? Only
the result mat
On 06.02.2007, at 08:59, Walter Vaughan wrote:
Is this still true in regards to Xeon's? I was looking at a server
with Quad Core Xeon 2 5335 @ 2.0GHz.
No, it's not true anymore. See
http://tweakers.net/reviews/657/1
for an interesting comparison.
cug
---(end of bro
On 31.01.2007, at 14:53, Lenorovitz, Joel wrote:
I do not know of any product, Slony included, that has built in
support
for a situation such as this, so I suspect all of the details will
have
to be handled in a custom fashion.
It is not relevant for you as your are using PostgreSQL (for g
Am 30.01.2007 um 12:11 schrieb Tony Caduto:
Why? Seems to me if it was discussed that much it must be a very
sought after feature.
How come it's not on the TO Do list for the future at least?
Is it because of some limitation of the core engine or something?
http://www.postgresql.org/docs/fa
On 23.08.2006, at 16:51 Uhr, Alvaro Herrera wrote:
Guido Neitzer wrote:
8<8<8<8<8<8<
2.2.1. Unstructured Header Field Bodies
Some field bodies in this standard are defined simply as
"unstructured" (which
On 23.08.2006, at 16:31 Uhr, Alvaro Herrera wrote:
Can you have multi-line subject lines? I didn't think that was
possible.
Yes. This is the header of a mail you sent to -patches:
Aha? Subject is an "unstructured header field" and according to RFC
2822 [1]:
8<8<8<--
On 11.07.2006, at 21:11 Uhr, Alvaro Herrera wrote:
I had the problem a few months ago, where my app server plugin and
the jdbc driver used prepared statements for selecting stuff from the
database. Most of the time, indexes weren't used at all, so
PostgreSQL performance was the worst I've ever s
On 11.07.2006, at 19:36 Uhr, Merlin Moncure wrote:
As to preparing
statements, I agree in principle although I don't know if that is a
good argument not to make the non-paramaterized interface more
powerful.
It is not, as prepared statements have the problem that they are only
optimized once
On 14.06.2006, at 14:12 Uhr, A. Kretschmer wrote:
Is there an easy way to copy the content including the table
structure,
indexes and so on from one db to another?
Create the new db with the old db as template.
Thanks, but as far as I can see, I have to disconnect all clients
from the p
On 14.06.2006, at 14:02 Uhr, Thomas Kellerer wrote:
pg_dump: http://www.postgresql.org/docs/8.1/static/app-pgdump.html
Found it. Thanks. I was just blind and thought, pg_dump can only re-
create the db with the same name.
Thanks,
Guido
---(end of broadcast)-
Hi.
Is there an easy way to copy the content including the table
structure, indexes and so on from one db to another?
Let's say I have a production db called db_production and want to
create a development db called db_dev with exactly the same content
on the same machine - just with the d
On 09.05.2006, at 16:52 Uhr, Reid Thompson wrote:
*WebObjects Distribution License
$699 per copy*
WebObjects, the premier web application server used by hundreds of
corporations, is now available for redistribution by web
application developers just like you.
Upon signature by Apple, the
On 09.05.2006, at 16:31 Uhr, Steve Atkins wrote:
Is that actually true? My understanding was that under the most recent
license changes it was not possible to deploy it to any platform other
than XServe.
Wrong. You are allowed to deploy on any platform you like, but only
Mac OS X Server is o
On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which would you recommend for end
users on multiple OSes?
You mean what tec
On 23.03.2006, at 9:50 Uhr, [EMAIL PROTECTED] wrote:
I currently use phpPgAdmin to make changes to the database, so it
would
be very handy if Postgres could add a change made to a lable
somewhere,
after which I gather all the rows with changes and put them in a SQL
query.
I mostly use the
On 20.03.2006, at 11:41 Uhr, Martijn van Oosterhout wrote:
What is the technical difference between adding a column to a table
and then apply a "set value = ..." to all columns and adding a column
with a default value = ...?
What version are you using:
# alter table a add column b int4 defaul
Hi.
What is the technical difference between adding a column to a table
and then apply a "set value = ..." to all columns and adding a column
with a default value = ...?
I have seen that the first duplicates all rows, I had to vacuum and
reindex the whole table. Okay so far, I have expect
On 07.03.2006, at 16:04 Uhr, Tom Lane wrote:
Because IN means "=", which is a member of the index opclass for the
second index but not the first.
Why do you care? Should be about the same result either way.
Only because I haven't set up the second index because I wasn't aware
of this fact.
On 07.03.2006, at 12:11 Uhr, A. Kretschmer wrote:
Yes, of cource. You can define
log_min_duration_statement = 100
to log all queries taking longer 100 ms.
Thanks.
cug
--
PharmaLine, Essen, GERMANY
Software and Database Development
smime.p7s
Description: S/MIME cryptographic signature
On 07.03.2006, at 12:09 Uhr, chris smith wrote:
Try without the quotes:
select id from dga_dienstleister where plz in (45257, 45259);
Same result, second index is used.
What is the table structure for dga_dienstleister ?
For the relevant column:
plz| chara
Hi.
Is there a reason why this query:
select id from dga_dienstleister where plz in ('45257', '45259');
doesn't use this index:
"dga_dienstleister_plz_index" btree (plz varchar_pattern_ops)
but uses this index:
"dga_dienstleister_plz_index2" btree (plz)
I had the first index setup f
Hi.
Is there a way to set up logging in a way that I can see queries
which trigger seq scans? Or to log queries "taking longer than xx ms"?
Background is, that it is nearly impossible to tell, which queries
are used in my applications as they are mostly generated by the
frameworks. Yester
On 01.03.2006, at 19:39 Uhr, falcon wrote:
Any one know of such a framework?
(I'm asking this in pgsql because such a framework will have to be
fairly closely linked to a database...and I mainly use pgsql).
Hmm. No. I don't think you can have this combined with what is often
called "busines
On 31.01.2006, at 17:38 Uhr, Rich Doughty wrote:
I'm not too fussed about a row-by-row comparison between the source
and the
copy. It's rather a case of a tool to check the datafiles'
integrity (such
as fsck, myisamchk, svnadmin verify etc).
If the fact that pg_dumpall returned successfully
On 31.01.2006, at 16:00 Uhr, Rich Doughty wrote:
i had considered pg_dump. i was hoping there was a utility similar
to fsck that could check for corruption. i'd like to verify now that
the data is ok, rather than coming across errors in 6 months time.
I have done this using JDBC (and the WebOb
On 22.12.2005, at 11:27 Uhr, Martijn van Oosterhout wrote:
For btrees at least, yes. Around a third of a page or about 2713 bytes
by default. For bigger things you probably want tsearch anyway.
Thanks.
cug
smime.p7s
Description: S/MIME cryptographic signature
Hi.
Is there a limitation of the length of a char or varchar(x) column
for indexing?
cug
smime.p7s
Description: S/MIME cryptographic signature
On 19.12.2005, at 12:14 Uhr, Marian Naghen wrote:
Can anyones suggest some readings about implementing
sequences w/o holes ?
Question: why?
I doubt that this is possible without heavy locking, which kills your
performance.
cug
--
PharmaLine Essen, GERMANY and
Big Nerd Ranch Europe - Pos
On 15.12.2005, at 9:10 Uhr, Brendan Duddridge wrote:
What about Sequoia? Is that better or worse than pgpool?
That looks interesting, I haven't seen it yet. Has anyone experiences
to share?
cug
smime.p7s
Description: S/MIME cryptographic signature
Hi Scott, hi Richard,
On 14.12.2005, at 17:30 Uhr, Scott Marlowe wrote:
This setup I'm talking about would have pgpool on each db server.
If you meant pgpool running on both application servers, that would
work
fine with slony in the background and pgpool in load balancing
mode, or
with p
On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote:
I'd be tempted to look at pgpool sitting between your application
and the database, and then replication from the one machine to the
other.
Right, I thought the same, BUT: I have two application servers (one
on each machine) connecting to
Hi.
I have two server boxes (Apple Xserve G5). WebServers and
applications are installed on both machines, the load is distributed
by a loadbalancer to both machines.
How can I make a setup in a way that the database is also tolerant
against failure? What I actually need is a mechanism th
On 02.12.2005, at 20:02 Uhr, Jaime Casanova wrote:
so the way to do it is create a trigger that record in a table the
number of rows...
As there are SO MANY questions about the "count(*)" issue, I wonder
whether it makes sense to add a mechanism which does exactly the
method mentioned abov
On 11.11.2005, at 9:33 Uhr, Guido Neitzer wrote:
Yes, as far as I know there is no other way of changing the locale
settings. Hopefully you are on Linux! If you deploy on Mac OS X or
*BSD it won't work even with a change.
I have to correct me: Hopefully you are not on Mac OS X. On Mac
On 10.11.2005, at 21:31 Uhr, Michael Schuerig wrote:
My current conjecture is that I'd have to re-initialize the cluster
with
a utf-8 collation. Is this correct? Right now I don't have access to
the machine and can't check this.
Yes, as far as I know there is no other way of changing the loc
On 07.11.2005, at 14:07 Uhr, Martijn van Oosterhout wrote:
We had this question earlier this week. Mac OS X uses the locales from
FreeBSD, and neither support UTF-8 collation at all. You'll see
exactly
the same results from other UNIX utilities.
I think I was the one who asked.
I worked on
Hi.
I have a problem with PostgreSQL and UTF-8 on my Mac OS X Powerbook.
- System is Mac OS X Client 10.4.3, PostgreSQL 8.1beta3
- initdb was called with -E UTF-8 --locale=de_DE.UTF-8
I have successfully build a LC_COLLATE file for ISO8859-15, and
ordering works there if I do the initdb wit
On 02.11.2005, at 11:47 Uhr, Martijn van Oosterhout wrote:
Ah you noticed that. Yes, many of the UTF-8 locales in FreeBSD simply
point to the ASCII versions which doesn't exactly work very well.
Right.
Only another FreeBSD system, these files are not portable. However,
the
source files for
On 01.11.2005, at 23:24 Uhr, Martijn van Oosterhout wrote:
PostgreSQL should get the same results as the command-line sort for
the
same values of LC_COLLATE. However, the value is fixed at initdb time
so maybe that's what's confusing you.
Yes, it gets the same results as sort.
I have tried
Hi.
I have a problem with the use of PostgreSQL on Mac OS X (10.4.x) and
selects with "order by". When there are german umlauts in the column
which is used to order, the sorted result is wrong.
As an example, I get:
a
b
ä
where it should be:
a
ä
b
Had someone here the same problem and s
67 matches
Mail list logo
