at 3:46 PM, Madison Kelly wrote:
> Miguel Miranda wrote:
>
>> Hi, the worst have ocurred, my server died (cpu), so i reinstalled another
>> server with the same postgres version.
>> I have the old data directory from the old server, how can i restore my
>> databases
Hi, the worst have ocurred, my server died (cpu), so i reinstalled another
server with the same postgres version.
I have the old data directory from the old server, how can i restore my
databases from this directory to the new one?
I dont have a backup (pg_dump,etc), just the main previus live data
sorry, i edited the date, the correct one is
05-03-2009 12:00:00 AM
If i group by day, it count 1 user for day 2009-05-03 in the output, so it
adds 1 to the total count of the range
regards
On Wed, May 6, 2009 at 3:51 PM, Erik Jones wrote:
>
> On May 6, 2009, at 2:48 PM, Miguel M
textbox, and right now i
dont have a java calendar at hand, i tried this with good result:
WHERE lastlogin::date BETWEEN '2009-05-01' AND '2009-05-02'
But now the query uses seq scan and not the index in lastlogin column.
Is there another way?
On Wed, May 6, 2009 at 3
Hi, what is the recommended way to select a range of dates?
Lets say a have a table with a lastlogin (timestamp) column and i want
toknow what users logged in for last time between 2009-05-01 and 2009-05-02?
I know that a simple
where lastlogin between '2009-05-01' and '2009-05-02' doesnt work b
I cant use a unique index because i only want to check for duplicates where
processed = 2, for simplicity i did not include that condition in the
example.
On Fri, Apr 24, 2009 at 5:50 PM, Scott Marlowe wrote:
> On Fri, Apr 24, 2009 at 5:37 PM, Miguel Miranda
> wrote:
> > hi , i
hi , i hava a table:
CREATE TABLE public.cdr_ama_stat (
id int4 NOT NULL DEFAULT nextval('cdr_ama_stat_id_seq'::regclass),
abonado_a varchar(30) NULL,
abonado_b varchar(30) NULL,
fecha_llamada timestamp NULL,
duracion int4 NULL,
puerto_a varchar(4) NULL,
puerto_b varchar(4) NULL,
tipo_llamada char(
Thomas Chille wrote:
Hi,
we are planning to use Postgresql 8.0 on a SUN Fire v40z Server with 4
SingleCore Opterons. It will be later replaced by an DualCore
Opterons.
Would you prefer using Solaris or Linux?
Thanks in Advance,
Thomas
---(end of broadcast)-
