Rob Adams wrote:
> I'm trying to demonstrate recovery using the "continuous archiving"
> backup technique. I'm using 8.3 on Windows.
>
> I made a base backup while the postgres was running using the following
> batch file:
>
> --
> psql -d test_database -U user_name -c "S
hi,
I am trying to compile the postgres-r patch, but ran into problems.. Probably
just a simple lack of understanding of the make system. Any help is appreciated.
I got the CVS head for postgres on Jul-31 and applying the Jul-31 patch from
here: http://www.postgres-r.org/downloads/. The patch a
On 2008-08-03 12:12, Sim Zacks wrote:
> SELECT m.message_idnr,k.messageblk
> FROM dbmail_messageblks k
> JOIN dbmail_physmessage p ON k.physmessage_id = p.id
> JOIN dbmail_messages m ON p.id = m.physmessage_id
> WHERE
> mailbox_idnr = 8
> AND status IN (0,1 )
> AND k.is_header = '0'
> GROUP BY
Hi!
We wish to provide our users with a simple-to-use web-based processor-selection
tool, where a user could select a couple of attribute values and be presented
with a list of matching processors. The basis of the required data would be
provided by our editors as Excel documents of the followi
Hello,
I am a developer working on postgres. I just wrote a function which ll
return a refcurosor as shown below.
CREATE OR REPLACE FUNCTION reffunc(refcursor)
RETURNS refcursor AS
$BODY$
BEGIN
OPEN $1 FOR SELECT * FROM SAM1;
RETURN $1;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST
Hello,
I am a developer working on postgres. I just wrote a function which ll
return a refcurosor as shown below.
CREATE OR REPLACE FUNCTION reffunc(refcursor)
RETURNS refcursor AS
$BODY$
BEGIN
OPEN $1 FOR SELECT * FROM SAM1;
RETURN $1;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST
On Fri, 01 Aug 2008 10:33:59 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> > Well I reached 3Gb of work_mem and still I got:
>
> > "Seq Scan on catalog_categoryitem (cost=31747.84..4019284477.13
> > rows=475532 width=6)"
> > " Filter: (NOT (subp
sol=> \d stats;
Table "public.stats"
Column| Type | Modifiers
--++---
id | integer| not null
start_time | timestamp(0) without time zone | not null
...
Index
> This query from the console:
>
> select * from stats order by start_time;
>
> takes 8 seconds before starting its output. Am I wrong in assuming that
> the index on start_time should make ORDER BY orders of magnitude
> faster?
> Or is this already fast enough? Or should I max up some memory (bu
Adam Rich wrote:
This query from the console:
select * from stats order by start_time;
takes 8 seconds before starting its output. Am I wrong in assuming that
the index on start_time should make ORDER BY orders of magnitude
faster?
Or is this already fast enough? Or should I max up some memory
Sim Zacks <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Could we see EXPLAIN ANALYZE, not EXPLAIN? Without actual facts
>> to work from, any suggestions would be mere guesswork.
> " -> Seq Scan on dbmail_messageblks k
> (cost=0.00..39193.21 rows=259 width=764) (actual time=30.662
"Adam Rich" <[EMAIL PROTECTED]> writes:
>> This query from the console:
>> select * from stats order by start_time;
>> takes 8 seconds before starting its output. Am I wrong in assuming that
>> the index on start_time should make ORDER BY orders of magnitude
>> faster?
> Postgresql won't use the i
> >
> > However, if you limit the number of rows enough, you
> might force it
> > to use an index:
> >
> > select * from stats order by start_time limit 1000;
> >
>
> Thanks! Since LIMIT/OFFSET is the typical usage pattern for
> a paginated
> data set accessed from the Web (which is my case),
On Mon, Aug 04, 2008 at 08:35:28AM -0500, Adam Rich wrote:
> > This query from the console:
> >
> > select * from stats order by start_time;
> >
> > takes 8 seconds before starting its output. Am I wrong in assuming that
> > the index on start_time should make ORDER BY orders of magnitude
> > fas
Julio Cesar Sánchez González wrote:
> A B wrote:
>> I have a table with rows like this
>> A 1
>> A 1
>> B 3
>> B 3
>> C 44
>> C 44
>> and so on.
>>
>> and I want it to be
>> A 1
>> B 3
>> C 44
>>
>> so how can I remove the all the duplicate lines but one?
>>
>>
You think this would help?
create t
Hi all,
is there some way to disable and enable login in PostgreSQL? I would like to
have only local login enabled when the server starts and make some checks
before allowing general login.
Best regards and thanks,
Teemu Juntunen
On Sun, 3 Aug 2008, Rob Adams wrote:
I made a base backup while the postgres was running using the following batch
file:
psql -d test_database -U user_name -c "SELECT pg_start_backup('test');"
What did you have archive_command set to? That needs to dump the WAL
files generated while the bac
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I have a table of the form
aid cid
- -
1 123
2 456
3 667
3 879
3 123
4 878
4 456
4 123
5 999
5 667
5 879
My goal is to identify for each pair of cid values, the number of
ti
what error show the log file?
--- On Mon, 8/4/08, Greg Smith <[EMAIL PROTECTED]> wrote:
> From: Greg Smith <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] recovery via base + WAL replay failure
> To: "Rob Adams" <[EMAIL PROTECTED]>
> Cc: "postgres general"
> Date: Monday, August 4, 2008, 5:58 PM
>
The WAL file archiving appears to be working correctly. These are the
settings I'm using for archiving the WAL files:
archive_mode = on
archive_command = 'copy %p C:\backup\%f /A'
archive_timeout = 15s
Thanks again,
--Rob
Greg Smith wrote:
On Sun, 3 Aug 2008, Rob Adams wrote:
I made a b
You can using the pg_hba.conf file. Set the non-local accounts to
reject when you start the database. After you finish your scripts,
change the pg_hba.conf file to enable logins and then use pg_ctl reload
to enable the new pg_hba.conf file.
host all all 0.0.0.0/0 reject
And then change it
Hiroshi-san,
Is this something specific to windows? If so, should this be consider a bug?
Robert Treat
On Sunday 03 August 2008 18:01:05 Hiroshi Saito wrote:
> Hi.
>
> Sorry, it was not included in release.
> please see,
> http://winpg.jp/~saito/pg_work/OSSP_win32/
>
> Regards,
> Hiroshi Saito
Teemufollow the instructions for implementing SSL in
postgreshttp://developer.postgresql.org/pgdocs/postgres/ssl-tcp.htmlbut you'll
have to start by compiling in the SSL module into postgres build
http://developer.postgresql.org/pgdocs/postgres/install-procedure.html./configure
--with-openssl
k
On Mon, Aug 4, 2008 at 2:08 PM, Rajarshi Guha <[EMAIL PROTECTED]> wrote:
> select count(aid) where cid = 123 and cid = 456;
>
> but I was wondering whether I could construct a single SQL statement to do
> this.
>
> Any pointers would be appreciated,
Typed into gmail, so may need some tweaking, bu
On Mon, Aug 4, 2008 at 1:02 PM, David Wilson <[EMAIL PROTECTED]> wrote:
> On Mon, Aug 4, 2008 at 2:08 PM, Rajarshi Guha <[EMAIL PROTECTED]> wrote:
>
>> select count(aid) where cid = 123 and cid = 456;
>>
>> but I was wondering whether I could construct a single SQL statement to do
>> this.
>>
>> An
There is nothing in the log file (in pg_log dir) with regard to this.
Should I set any particular parameter in the postgresql.conf file to log
information about a failed startup? I have not altered or uncommented
any lines in the "ERROR REPORTING AND LOGGING" section of the conf file.
Thanks
On 2:08 pm 08/04/08 Rajarshi Guha <[EMAIL PROTECTED]> wrote:
> paircount
> - -
> 123 & 456 1
> 667 & 879 2
create temp table aic_cid
(
id smallint,
cid smallint
);
insert into aic_cid values (1,123);
insert into aic_cid values (2,456);
insert into aic_cid values (3,66
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Aug 4, 2008, at 4:55 PM, Francisco Reyes wrote:
On 2:08 pm 08/04/08 Rajarshi Guha <[EMAIL PROTECTED]> wrote:
paircount
- -
123 & 456 1
667 & 879 2
select a.cid as ac, b.cid as bc, count(*) from aic_cid a left
On mán, 2008-08-04 at 17:00 -0400, Rajarshi Guha wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> On Aug 4, 2008, at 4:55 PM, Francisco Reyes wrote:
> > On 2:08 pm 08/04/08 Rajarshi Guha <[EMAIL PROTECTED]> wrote:
> >> paircount
> >> - -
> >> 123 & 456 1
>
Rajarshi Guha wrote
>
> On Aug 4, 2008, at 4:55 PM, Francisco Reyes wrote:
>> On 2:08 pm 08/04/08 Rajarshi Guha <[EMAIL PROTECTED]> wrote:
>>> paircount
>>> - -
>>> 123 & 456 1
>>> 667 & 879 2
>
>
>
>> select a.cid as ac, b.cid as bc, count(*) from aic_cid a left
Heres a backtrace on a fresh core file
http://privatepaste.com/911BTjYrY1
Does this change get us any closer?
--- On Tue, 22/7/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
> From: Glyn Astill <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Initdb problem on debian mips cobalt: Bus error
> To: "Tom
Hi Robert-san
Ahh yes..
I'm sorry delaying release bugfix was not included in pg8.3.3.
Then,I will adjust next release(1.6.3/4) with Rarf-san again.
Regards,
Hiroshi Saito.
>Hiroshi-san,
>
>Is this something specific to windows? If so, should this be consider a bug?
>
>Robert Treat
>
>On Sunda
I found error log entries in the Windows Event Viewer:
2008-08-01 23:57:55 GMT FATAL: could not remove old lock file
"postmaster.pid": Permission denied
2008-08-01 23:57:55 GMT HINT: The file seems accidentally left over,
but it could not be removed. Please remove the file
Glyn Astill <[EMAIL PROTECTED]> writes:
> Heres a backtrace on a fresh core file
> http://privatepaste.com/911BTjYrY1
> Does this change get us any closer?
Not really ... there's no plausible reason to crash there, either.
Just for entertainment's sake, try recompiling with -O0 instead of the
def
"Tom Lane" <[EMAIL PROTECTED]> writes:
> (Rather than trying to browbeat configure into doing this, I'd suggest
> manually adjusting CFLAGS in src/Makefile.global, then "make clean" and
> rebuild.)
eh? either of these should work fine:
./configure --enable-debug CFLAGS=-O0
CFLAGS=-O0 ./configu
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>> (Rather than trying to browbeat configure into doing this, I'd suggest
>> manually adjusting CFLAGS in src/Makefile.global, then "make clean" and
>> rebuild.)
> eh? either of these should work fine:
> ./configur
Gregory Stark wrote:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>
> > (Rather than trying to browbeat configure into doing this, I'd suggest
> > manually adjusting CFLAGS in src/Makefile.global, then "make clean" and
> > rebuild.)
>
> eh? either of these should work fine:
>
> ./configure --enable
ravi kiran wrote:
> Hello,
>
> I am a developer working on postgres. I just wrote a function which ll
> return a refcurosor as shown below.
[snip]
> i have problems accessing this function from my middle tier i.e VC++.
>
> I wrote a VC statement to retrieve values from this refcursor using a re
All,
I have 2 tables with a lot of columns with similar names. I'd like to
join both tables and include all columns from each without naming
collisions. I can use the 'AS' to rename a single column, but is there
a way to do the rename in bulk by just appending a prefix or suffix to
the colu
Results below:
> ... but given that, I wonder whether the cost isn't from fetching
> the toasted messageblk data, and nothing directly to do with either
> the encode() call or the ~~ test. It would be interesting to compare
> the results of
>
> explain analyze select encode(messageblk, 'escape')
40 matches
Mail list logo
