On Mon, Mar 2, 2009 at 8:24 PM, shadrack wrote:
> On Mar 2, 5:35 pm, pie...@hogranch.com (John R Pierce) wrote:
>> Tom Lane wrote:
>> > shadrack writes:
>>
>> >> My basic question is...are php4 and postgresql 8.3 compatible?
>> >> I'm running Linux Redhat 3.4.6, php4.3.9, and postgresql 8.3. I k
John,
>> Is it possible to host postgreSQL on Amazon's cloud? What are the issues
>> involved?
>
> in theory, sure. anything is possible.
>
> in practice, as I understand it from my relatively superficial reading, fast
> storage is fairly expensive and limited in the EC2 compute cloud, and also
I'd like to have different users mainly to have a different search
schema path.
Things may evolve so this is not going to be the only reason to have
more than one user.
But I'm faced with the problem of granting the same access of the
owner of the db to the other users.
But I read:
http://www.po
>
>
> Again, this is a lot of work to avoid master / slave with failover.
> Are you sure it's really needed for your situation?
>
>
What is the most straightforward and simple way to achieve master slave with
failover?
Preferably a solution that would have decent monitoring, alerting and
failback
I found today that postgres EnterpriseDB supports Amazon EC2. On a
shoestring budget EnterpriseDB is just as much an option as Oracle ;-(
So, question is what makes EnterpriseDB more suitable for the cloud than
plain vanilla postgreSQL?
Anyone?
With best regards.
Sanjay.
On Tue, Mar 3, 2009 at
On Tuesday 03 March 2009 4:41:48 am Sanjay Arora wrote:
> I found today that postgres EnterpriseDB supports Amazon EC2. On a
> shoestring budget EnterpriseDB is just as much an option as Oracle ;-(
>
> So, question is what makes EnterpriseDB more suitable for the cloud than
> plain vanilla postgreS
I don't know exactly, but here here is a paper from Elastra
http://elastra.com/about/2008/03/07/enterprisedb-to-deliver-oltp-database-using-amazon-cloud/
Oleg
On Tue, 3 Mar 2009, Sanjay Arora wrote:
I found today that postgres EnterpriseDB supports Amazon EC2. On a
shoestring budget Enterprise
Adrian Klaver writes:
> Nothing. I have created a Postgres instance on an EC2 virtual machine with
> attached EBS(Elastic Block Storage). I only got as far as creating in it and
> verifying it would run, no benchmarking. EC2 instances have storage as part
> of
> the instance but it is temporar
Thanks. If there are many tables owned by me and some other users, are
there any easy ways to do that?
On Mon, Mar 2, 2009 at 9:23 PM, Scott Marlowe wrote:
> On Mon, Mar 2, 2009 at 5:31 PM, Roger Chen wrote:
>> Hi,
>> Can anyone tell me how to do that? I could find that in man page of
>> pg_dump
Ups, sorry, I'm idiot... changes from the default casting to text is
really helpful in clearing brain bugs...
Роман Маширов wrote:
Hi!
Excuse me, if this been discussed before, but following thing seems to
me a little bit strange:
select '2009-01-12'::date - null::date < '1 day'::interval;
On Mar 3, 2009, at 4:35 AM, Ivan Sergio Borgonovo wrote:
But I read:
http://www.postgresql.org/docs/8.3/static/sql-grant.html
The SQL standard does not support setting the privileges on more
than one object per command.
This is going to make maintenance and development a PITA every time I
add
--- On Tue, 3/3/09, Roger Chen wrote:
> >> Hi,
> >> Can anyone tell me how to do that? I could find
> that in man page of
> >> pg_dump. Thanks.
> >
> > pg_dump -t table1 -t table2
> >
> Thanks. If there are many tables owned by me and some other
> users, are
> there any easy ways to do that?
>
On Tuesday 03 March 2009 7:25:17 am Tom Lane wrote:
> Adrian Klaver writes:
> > Nothing. I have created a Postgres instance on an EC2 virtual machine
> > with attached EBS(Elastic Block Storage). I only got as far as creating
> > in it and verifying it would run, no benchmarking. EC2 instances hav
HI. I made a small alteration to a table (added a column).
Now when I do:
vacuum analyze TABLENAME
or
delete from TABLENAME where id = 99
Nothing happens! The carriage return means the my shell cursor goes to
the next line, but it just stays there. I thought something may be
happening sile
Hi!
Excuse me, if this been discussed before, but following thing seems to
me a little bit strange:
select '2009-01-12'::date - null::date < '1 day'::interval;
ERROR: operator does not exist: integer < interval
LINE 1: select '2009-11-12'::date - null::date < '1 day'::interval;
Phoenix Kiula writes:
> Now when I do:
> vacuum analyze TABLENAME
> or
> delete from TABLENAME where id = 99
> Nothing happens! The carriage return means the my shell cursor goes to
> the next line, but it just stays there.
Did you forget the semicolon?
regards, tom l
On Tuesday 03 March 2009, Phoenix Kiula wrote:
> HI. I made a small alteration to a table (added a column).
>
> Now when I do:
>
> vacuum analyze TABLENAME
>
> or
>
> delete from TABLENAME where id = 99
>
> Nothing happens! The carriage return means the my shell cursor goes to
> the next line,
On Wed, Mar 4, 2009 at 12:10 AM, Tom Lane wrote:
> Phoenix Kiula writes:
>> Now when I do:
>> vacuum analyze TABLENAME
>> or
>> delete from TABLENAME where id = 99
>> Nothing happens! The carriage return means the my shell cursor goes to
>> the next line, but it just stays there.
>
> Did you
> commit the transaction where you altered the table. It has an open lock on
> the table.
=# commit;
WARNING: there is no transaction in progress
COMMIT
Time: 0.282 ms
So no, there's nothing pending.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
Although when I try this:
select pg_class.relname,pg_locks.* from pg_class,pg_locks where
pg_class.relfilenode=pg_locks.relation;
There are many rows!
How can I get rid of these open locks?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
- "Phoenix Kiula" wrote:
> > commit the transaction where you altered the table. It has an open
> lock on
> > the table.
>
>
>
> =# commit;
>
> WARNING: there is no transaction in progress
> COMMIT
> Time: 0.282 ms
>
>
> So no, there's nothing pending.
>
> --
Are you connected to t
On Wed, Mar 4, 2009 at 12:36 AM, Adrian Klaver wrote:
>
> Are you connected to the right database?. I have been in that situation,
> looking at the log for db A and doing things in db B.
Thanks. I only have one database, so yes I am connected to it.
I have the lock file in /tmp:.s.PGSQL.54
- "Phoenix Kiula" wrote:
> On Wed, Mar 4, 2009 at 12:36 AM, Adrian Klaver
> wrote:
> >
> > Are you connected to the right database?. I have been in that
> situation, looking at the log for db A and doing things in db B.
>
>
> Thanks. I only have one database, so yes I am connected to it.
I guess my question is, how should I remove all pending locks on a
table so that I can get on with the rest of the stuff?
I mean, even if I can now find an offending RULE on the table, I
cannot replace or remove it. '
Thanks for any pointers!
--
Sent via pgsql-general mailing list (pgsql-genera
Phoenix Kiula writes:
> How can I get rid of these open locks?
Close the transactions that are holding them. Look into
pg_stat_activity and pg_prepared_xacts.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
On Wed, Mar 4, 2009 at 12:55 AM, Phoenix Kiula wrote:
> I guess my question is, how should I remove all pending locks on a
> table so that I can get on with the rest of the stuff?
>
> I mean, even if I can now find an offending RULE on the table, I
> cannot replace or remove it. '
Any ideas? I
On Wed, Mar 4, 2009 at 1:17 AM, Tom Lane wrote:
> Phoenix Kiula writes:
>> How can I get rid of these open locks?
>
> Close the transactions that are holding them. Look into
> pg_stat_activity and pg_prepared_xacts.
Thanks for this. But can I simply delete all the pg_locks table? Or
delete all
On Wed, Mar 4, 2009 at 1:23 AM, Phoenix Kiula wrote:
> On Wed, Mar 4, 2009 at 1:17 AM, Tom Lane wrote:
>> Phoenix Kiula writes:
>>> How can I get rid of these open locks?
>>
>> Close the transactions that are holding them. Look into
>> pg_stat_activity and pg_prepared_xacts.
>
>
> Thanks for th
Ivan Sergio Borgonovo wrote:
I'd like to have different users mainly to have a different search
schema path.
Things may evolve so this is not going to be the only reason to have
more than one user.
But I'm faced with the problem of granting the same access of the
owner of the db to the other use
phoenix.ki...@gmail.com (Phoenix Kiula) writes:
> On Wed, Mar 4, 2009 at 12:55 AM, Phoenix Kiula
> wrote:
>> I guess my question is, how should I remove all pending locks on a
>> table so that I can get on with the rest of the stuff?
>>
>> I mean, even if I can now find an offending RULE on the t
On Tue, 03 Mar 2009 09:29:17 -0800
John R Pierce wrote:
> Ivan Sergio Borgonovo wrote:
> > I'd like to have different users mainly to have a different
> > search schema path.
> > Things may evolve so this is not going to be the only reason to
> > have more than one user.
> > But I'm faced with t
On Tue, Mar 03, 2009 at 10:25:17AM -0500, Tom Lane wrote:
> Adrian Klaver writes:
> > Nothing. I have created a Postgres instance on an EC2 virtual machine with
> > attached EBS(Elastic Block Storage). I only got as far as creating in it
> > and
> > verifying it would run, no benchmarking. EC2
Phoenix Kiula writes:
> I guess my question is, how should I remove all pending locks on a
> table so that I can get on with the rest of the stuff?
>
> I mean, even if I can now find an offending RULE on the table, I
> cannot replace or remove it. '
You're off on the wrong track. Locks are held
On Tue, Mar 3, 2009 at 3:57 AM, Tim Uckun wrote:
>
>>
>>
>> Again, this is a lot of work to avoid master / slave with failover.
>> Are you sure it's really needed for your situation?
>>
>
> What is the most straightforward and simple way to achieve master slave with
> failover?
We use Slony at wo
I'd put them all into the same schema and dump that.
pg_dump -n schemaname
On Tue, Mar 3, 2009 at 8:30 AM, Roger Chen wrote:
> Thanks. If there are many tables owned by me and some other users, are
> there any easy ways to do that?
>
> On Mon, Mar 2, 2009 at 9:23 PM, Scott Marlowe wrote:
>> On
On Mar 3, 2009, at 12:39 PM, Joshua Tolley wrote:
On Tue, Mar 03, 2009 at 10:25:17AM -0500, Tom Lane wrote:
Adrian Klaver writes:
Nothing. I have created a Postgres instance on an EC2 virtual
machine with
attached EBS(Elastic Block Storage). I only got as far as creating
in it and
verifyi
Hi everyone:
I really wanted to let everyone know that I've created @PGSQL_Announce on
Twitter and setup a cron job to parse the feed and post it to Twitter.
It's been working for a little while now and I think it's stable enough to
announce to the world.
Forgive me if this isn't the way to ann
Is there a way to get the date/time of the last commit on a database?
Tom
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Mar 2, 2009 at 7:40 AM, Gauthier, Dave wrote:
> I believe that op system side buffering can play a role too. I our case,
> the DB server (machine & op sys) caches data that it pulled from disk (not
> necessarily from a DB) and also the disk servers do the same. If a block
> was removed f
Am 2009-03-03 21:38:39, schrieb Douglas J Hunley:
> Hi everyone:
> I really wanted to let everyone know that I've created @PGSQL_Announce on
> Twitter and setup a cron job to parse the feed and post it to Twitter.
> It's been working for a little while now and I think it's stable enough to
> ann
Hi,
Mauritius use daylight saving since 2008-11.
The Olson database has been updated to reflect the Mauritius timezone change
at the end of 2008 (maybe since tzdata-2008f or tzdata-2008g, not really
sure).
Postgresql is supposed to have the correct Mauritius timezone since 8.3.5
(http://www.p
41 matches
Mail list logo
