Hi Shane,
Thanks for the answer.
Actually I want to distribute specific database to a lot of different
clients(different OS/Linux;Windows/, different CPU/AMD;Intel/), and I was
thinking about only copying the files instead of dump/restore(which is must
slower operation). From your answer I guess it
Hullo List,
Following up on a recent thread
(http://archives.postgresql.org/pgsql-general/2007-11/msg00064.php) ...
Next question and one that I'm not sure how to phrase: how does one
become a Postgres-savvy* DBA? Just by working with it as a developer
and then moving "up the ranks"? (i.e worki
Thank you to all for your thoughts and responses.
Kevin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Charles Seaton <[EMAIL PROTECTED]> writes:
> Thanks for your response. I am wondering whether it is postgres 8.2.5
> that resolves the problem or your time zone setting.
This behavior changed in PG 8.1. Per the release notes:
* Add a separate day field to type interval so a one day interval can
Hi Mathias,
Actually, I did change the /tmp permissions to 1777 after I sent the
last post, but thank you for confirming that that was the right thing
to do. As far as folder ownership, I am not running Mac OSX Server, I
am running the client version and I am the only user. I installed
Niklas,
Thanks for your response. I am wondering whether it is postgres 8.2.5
that resolves the problem or your time zone setting.
I am running postgres 8.0.3. My server time zone is set to US/Pacific.
Setting my server time zone to one that does not have daylight saving
time causes the prob
Rainer Bauer <[EMAIL PROTECTED]> writes:
> Wouldn't it be possible to copy the database folder and somehow instruct the
> postmaster to include the copied data after a restart?
See CREATE DATABASE's TEMPLATE option. It's a bit crude but I think
it'll help.
regards, tom la
Abandoned wrote:
>I tryed pg_dump but it is very slowly. Are there any faster way to
>copy database?
Actually, I was looking for something along the same line.
I often want to test some functionality in my program based on the same
dataset. However, dump/restore takes too long to be of any use.
Yes..I concur that every business should retain a dedicated DBA with the
caveat that the DBA's expertise states a bit more than
'changed the DBA password'
M--
- Original Message -
Wrom: HDMNNSKVFVWRKJVZCMHVIBGDADRZFSQHYUCDDJB
To:
Sent: Saturday, November 03, 2007 11:40 AM
Subject: Re: [GE
On Fri, Nov 02, 2007 at 01:26:23AM -0400, Tom Lane wrote:
> out there who don't get past that hurdle and just give up. It would
> be interesting to troll the mysql lists for evidence of the downside
> of their default ... which'd be along the line of "someone broke into
> my completely insecure da
--- Greg Smith <[EMAIL PROTECTED]> wrote:
> On Fri, 2 Nov 2007, Kevin Hunter wrote:
>
> > I don't have "ammo" to defend (or agree?) with my
> friend when he says
> > that "Postgres requires a DBA and MySQL doesn't so
> that's why they
> > choose the latter."
>
> [snip]
>
> To step back for a
On 11/1/07, Kevin Hunter <[EMAIL PROTECTED]> wrote:
> - More in line with the conversation with my friend, what/why is it that
> Postgres needs a DBA while MySQL doesn't? I highly suspect that the
> assumption that MySQL doesn't need a DBA is incorrect, but that's what
> was posed to me and I coul
On Friday 02 November 2007 00:03, Kevin Hunter wrote:
> However, I'm not a DBA and only minimally know what's involved in doing
> the job, so I don't have "ammo" to defend (or agree?) with my friend
> when he says that "Postgres requires a DBA and MySQL doesn't so that's
> why they choose the latte
On 3 nov 2007, at 12.26, Charles Seaton wrote:
select ('12/31/2006 UTC'::timestamptz + '307 days 02:45:30'::interval)
However, this gives an incorrect result (off by 1 hour)
"2007-11-02 18:45:30-07"
Have you checked your servers TimeZone setting? Also, which Postgres
version are you running?
Recently, in working with some data that was expressed as day of year +
time, I discovered an unexpected behavior in postgres's time handling. I
am wondering whether this is a bug or expected behavior that I simply
don't understand.
Given a day of year 307 and a time 04:45:30 UTC in 2007, an o
Mikko Partio wrote:
On Nov 2, 2007 8:45 PM, Kynn Jones <[EMAIL PROTECTED]> wrote:
PS: As an aside to the list, as a programmer, when I'm starting out in
language, I learn more than I can say from reading source code written
by the experts, but for some reason I have had a hard time coming
acros
On Sat, Nov 03, 2007 at 11:42:39AM +0400, rihad wrote:
> Does this mean that a condition like "WHERE ... [AND] lhs.a=rhs.b [AND]
> ..." where rhs.b is already unique-indexed, also requires (non-unique)
> index on lhs.a for maximal join speed? Otherwise why would they want to
> say that?
No, as
17 matches
Mail list logo
