Dear all,
Today I by mistake deleted all the contents of pg_log & pg_xlog
directory and my Postgresql refuses to start due to the below error :-
2011-04-18 10:51:39 ISTLOG: database system was interrupted; last known
up at 2011-04-18 10:06:42 IST
2011-04-18 10:51:39 ISTLOG: could not open f
On 04/18/2011 04:04 AM, Stefan Keller wrote:
5. Optimize and secure session by following parameters:
SET transaction_read_only TO FALSE;
SET TRANSACTION READ ONLY;
AFAIK, neither of those have any effect on security. They're purely
advisory hints to Pg.
Personally I think it'd be
Hi
I discovered the 'fields' option of 'interval', but i can't figure out
from the docs how it is supposed to work. Are "hour to minute" and "day
to minute" really the same thing? And if not, in what circumstances are
they treated differently?
psql (8.4.7)
Type "help" for help.
postgres=> s
Clemens Eisserer Friday 08 April 2011 23:44:21
> Hi,
>
> I have a query where I UNION several select statements which return
> IDs of type INTEGER.
>
> This works well, if the IDs don't need to be sorted:
> > SELECT id FROM table WHERE id IN ((select id FROM table WHERE ...) UNION
> > (SELECT id
On 04/17/2011 03:52 AM, Phoenix Kiula wrote:
Hi,
Need some help here. I have a large table (200 million rows already).
There are two columns.
ColA
ColB
There is an index on ColA. It's an important column.
ColB is a boolean. Either 1 or 0.
For about 10% of the data, ColB is 1. Otherwise it's
I have a single-disk virtual Linux system and a read-only dataset
which is exposed to internet and completely replaced from time to
time.
I compiled following steps in order to secure and speedup such
PostgreSQL/PostGIS instance:
1. Re-configure PostgreSQL server as following:
a. Disabling aut
Alexander Farber writes:
> I have installed CentOS from a CentOS-5.6-x86_64-bin-DVD-1of2.iso
> and then installed PGDG because I want to have PostgreSQL 8.4.7:
I'm not sure if CentOS is caught up, but postgresql 8.4.7 is available
for RHEL5 from Red Hat --- it's called "postgresql84". Possibly y
On 04/17/11 11:05 AM, Alexander Farber wrote:
...
---> Package postgresql-libs.x86_64 0:8.4.7-1PGDG.rhel5 set to be updated
--> Running transaction check
---> Package compat-postgresql-libs.x86_64 0:4-1PGDG.rhel5 set to be updated
...
postgresql-devel-8.1.23-1.el5_6.1.i386 from updates has dep
Hello,
I have installed CentOS from a CentOS-5.6-x86_64-bin-DVD-1of2.iso
and then installed PGDG because I want to have PostgreSQL 8.4.7:
# rpm -Uvh
http://www.pgrpms.org/8.4/redhat/rhel-5-x86_64/pgdg-centos-8.4-2.noarch.rpm
# cat /etc/yum.repos.d/pgdg-84-centos.repo
[pgdg84]
name=PostgreSQL 8
"Robert J.C. Ivens" writes:
> I am not sure if there ever was a feature request for using defined
> column aliases in the rest of a query.
Yes, we've heard that before. Many times. It's not going to happen,
and here's why: it's flat out contrary to the SQL specification, as well
as to the basi
On 17 apr 2011, at 13:43, pasman pasmański wrote:
> Maybe you think about WITH queries?
>
> 2011/4/17, Robert J.C. Ivens :
>>
>> On 17 apr 2011, at 13:21, Leif Biberg Kristensen wrote:
>>
>>> On Sunday 17 April 2011 13:01:45 Robert J.C. Ivens wrote:
Hi,
I am not sure if there e
Maybe you think about WITH queries?
2011/4/17, Robert J.C. Ivens :
>
> On 17 apr 2011, at 13:21, Leif Biberg Kristensen wrote:
>
>> On Sunday 17 April 2011 13:01:45 Robert J.C. Ivens wrote:
>>> Hi,
>>>
>>> I am not sure if there ever was a feature request for using defined
>>> column
>>> aliases i
2011/4/17 Robert J.C. Ivens :
>
> On 17 apr 2011, at 13:21, Leif Biberg Kristensen wrote:
>
>> On Sunday 17 April 2011 13:01:45 Robert J.C. Ivens wrote:
>>> Hi,
>>>
>>> I am not sure if there ever was a feature request for using defined column
>>> aliases in the rest of a query. This would make que
On 17 apr 2011, at 13:21, Leif Biberg Kristensen wrote:
> On Sunday 17 April 2011 13:01:45 Robert J.C. Ivens wrote:
>> Hi,
>>
>> I am not sure if there ever was a feature request for using defined column
>> aliases in the rest of a query. This would make queries with a lot of
>> logic in those a
On Sunday 17 April 2011 13:01:45 Robert J.C. Ivens wrote:
> Hi,
>
> I am not sure if there ever was a feature request for using defined column
> aliases in the rest of a query. This would make queries with a lot of
> logic in those aliased columns a lot smaller and this easier to
> write/debug.
>
Clemens Eisserer Friday 08 April 2011 23:44:21
> Hi,
>
> I have a query where I UNION several select statements which return
> IDs of type INTEGER.
>
> This works well, if the IDs don't need to be sorted:
> > SELECT id FROM table WHERE id IN ((select id FROM table WHERE ...) UNION
> > (SELECT id
Hi,
I am not sure if there ever was a feature request for using defined column
aliases in the rest of a query.
This would make queries with a lot of logic in those aliased columns a lot
smaller and this easier to write/debug.
I already know you can use the following syntax:
SELECT col1, col2,
On Thu, April 14, 2011 20:54, Andrew Sullivan wrote:
> On Thu, Apr 14, 2011 at 12:27:34PM -0600, Scott Marlowe wrote:
>
>>> That's what a UPS and genset are for. Â Who writes critical stuff to
>>> *any*
>>> drive without power backup?
>>
>> Because power supply systems with UPS never fail.
>>
>
> R
On Thu, April 14, 2011 18:56, Benjamin Smith wrote:
> After a glowing review at AnandTech (including DB benchmarks!) I decided to
> spring for an OCX Vertex 3 Pro 120 for evaluation purposes. It cost about $300
> with shipping, etc and at this point, won't be putting any
>
> Considering that I sp
Hi,
Need some help here. I have a large table (200 million rows already).
There are two columns.
ColA
ColB
There is an index on ColA. It's an important column.
ColB is a boolean. Either 1 or 0.
For about 10% of the data, ColB is 1. Otherwise it's default is 0.
Now, my question: for that 10%,
20 matches
Mail list logo
