One possible answer to your issues is data partitioning. By
partitioning your data by date or primary key or some other field, you
can backup individual partitions for incremental backups. I run a
stats database that partitions by day daily and we can just backup
yesterday's partition each night.
>
>Dear Postgres users,
How about sending these to just one mailing list -- when you cross post
everybody gets two copies of each response.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gen
Hi CK:
First, it depends on what you mean by an application server. There
are people who in fact do very similar things with PostgreSQL,
essentially having it take on roles traditionally served by
middleware.
On Sat, Aug 13, 2011 at 8:57 AM, c k wrote:
> Dear Postgres users,
> from last few mon
hello to all
i am trying to find an "acceptable" solution for a backup strategy on one of
our servers (will be 8.4.8 soon, now its 8.4.7). i am familiar with both
logical (dump/restore) and physical backups (pg_start_backup, walarchives
etc) and have tried both in some other cases.
the issue her
thx a lot for the answers
we will upgrade to 8.4.8 and i will monitor the situation :)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PD-ALL-VISIBLE-flag-warnings-tp4692473p4697106.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via
On 08/13/2011 05:57 PM, c k wrote:
> Dear Postgres users,
> from last few months I am reading and searching for can postgresql used
as application server? As postgresql supports many languages like
pl/perl, pl/python etc, supports dblink like functions to connect to
other postgresql servers and now
> If it is possible to leave one row with specific values in the columns
> (loc_name, sample_date, param) and delete the additional ones, I'd like to
> learn how to do so. I know that I'll have use for these techniques with
> future data.
>
> Else, I'd like to delete all those rows with multiple
On Saturday, August 13, 2011 8:35:08 am c k wrote:
> I am not going to do stack trace right now, because I am using wireless
> broadband and is much costlier to download.
> But as other functions are working, may be it is related with other thing.
> I have forgotten to told that I am using virtual
On Sun, 14 Aug 2011, c k wrote:
I would like to generate content dynamically. I want minimum developers to
be required, simple and powerful security and administration, and most
importantly ability to respond to changes.
For my application the most important part is generating dynamic content.
can u please give me it's link.
I found ngx_postgres module.
there is nginx_htttp_postgresql_module
exactly to connect webserver directly to postgresql
and to OUTPUT query result to a browser.
http://wiki.nginx.org/3rdPartyModules
http://labs.frickle.com/nginx_ngx_postgres/
--
Se
can u please give me it's link.
I found ngx_postgres module.
Chaitanya Kulkarni
On Sun, Aug 14, 2011 at 12:14 AM, s...@bestmx.ru wrote:
> c k wrote:
>
>> Yes, I know that I can not create a simple web application using only
>> postgresql because we need a web server to server the html content.
c k wrote:
Yes, I know that I can not create a simple web application using only
postgresql because we need a web server to server the html content.
u r wrong.
u CAN!
there is nginx_htttp_postgresql_module
exactly to connect webserver directly to postgresql
and to OUTPUT query result to a brows
Yes, I know that I can not create a simple web application using only
postgresql because we need a web server to server the html content. I not
going to add web server functionalities to postgresql, but just want to use
existing features. I would like to generate content dynamically. I want
minimu
Thanks to David J. I have a working script to locate multiple rows having
the same values in three candidate columns. I used an enhanced version of
this script to copy those duplicate (and triplicate) records to a clone of
the original table.
Now I would like to delete those duplicates from t
Hello
2011/8/13 George MacKerron :
>> On 12/08/2011 17:26, George MacKerron wrote:
>>>
>>> The point of the function is that you can pass it any table name
>>> (along with some other parameters) and it returns rows from that
>>> named table.
>>
>> OK, fair enough but what exactly are you tryin
On Aug 13, 2011, at 11:57, c k wrote:
> Dear Postgres users,
> from last few months I am reading and searching for can postgresql used as
> application server? As postgresql supports many languages like pl/perl,
> pl/python etc, supports dblink like functions to connect to other postgresql
>
On 12 Aug 2011, at 19:17, Merlin Moncure wrote:
>>> you can't have it both ways. at the time the function call is
>>> executed, the return type/fields must be known. you can do this by
>>> either a. explicitly defining the function return type or b.
>>> describing the function return type in the
> On 12/08/2011 17:26, George MacKerron wrote:
>>
>> The point of the function is that you can pass it any table name
>> (along with some other parameters) and it returns rows from that
>> named table.
>
> OK, fair enough but what exactly are you trying to do that a simple
> SELECT won't do?
Dear Postgres users,
from last few months I am reading and searching for can postgresql used as
application server? As postgresql supports many languages like pl/perl,
pl/python etc, supports dblink like functions to connect to other postgresql
servers and now features are in development to use ext
I am not going to do stack trace right now, because I am using wireless
broadband and is much costlier to download.
But as other functions are working, may be it is related with other thing.
I have forgotten to told that I am using virtual machine for windows. For
even this the normal python interp
20 matches
Mail list logo
