Hello:
I find that the real timestamp format(got from the file which is produced by
copying binary to ) is different from what i find in timestamp_send func.
i do think that the binary format of a timestamp "2006-04-18 11:20:20" should
be "44 2B B0 6A 00 00 00 00" standing for "secs:1143713898
"Qingqing Zhou" <[EMAIL PROTECTED]> wrote
> As I reviewed the win32/sema.c, there is some code that I am not clear,
can
> anybody explain please?
>
There is another problem related to concurrent operations on win32 sema. Say
two processes are doing semop(+1) concurrently. Look at this code:
/*
On Sun, 2006-04-16 at 16:44 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > It seems that we should write an API to allow a backup device to ask for
> > blocks from the database.
>
> I don't think we have the manpower or interest to develop and maintain
> our own backup tool
Gevik Babakhani wrote:
> Could someone explain the numbering logic in naming the relations?
There is none. The numbers are presumably assigned in some
lowest-available manner, but over the years it has become pretty
random.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---
Hello all,
Could someone explain the numbering logic in naming the relations? Why
#define DatabaseRelationId 1262.
I guess not being involved from the beginning has its disadvantages. but
it is very exiting and fun trying to learn the internals by gdb and
asking lots of questions :)
Regards,
Gev
Hello again :)
> It doesn't seem particularly complicated: inside the connection-startup
> transaction done by InitPostgres, you could check to make sure the
> selected user has the CONNECT privilege on the selected database.
> [ looks at code... ] Actually ReverifyMyDatabase is the right place,
Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > On Mon, Apr 17, 2006 at 03:00:58PM -0400, Tom Lane wrote:
> > > I've applied a patch for this. On reflection, the CHECKPOINT during
> > > pg_start_backup was actually necessary for torn-page safety even without
> > > full_page_writes off. The reason
Jim C. Nasby wrote:
> On Mon, Apr 17, 2006 at 03:00:58PM -0400, Tom Lane wrote:
> > I've applied a patch for this. On reflection, the CHECKPOINT during
> > pg_start_backup was actually necessary for torn-page safety even without
> > full_page_writes off. The reason is that the torn-page risk occu
On Sat, Apr 15, 2006 at 03:05:20PM -0400, Jonah H. Harris wrote:
> All ideas welcome!
I know it's not directly PostgreSQL related, but I'd love to see the
dbt* code improved. Items on my wish-list:
- make it easy to run the test framework and clients on a seperate
machine from the database serv
I wrote:
> I attempted to send this additional info to the list but I think the
> message got dropped on the floor by the mailing list software or by
> the spam filter.
>
> I'll put the files on a web server and post links to them here.
You can find them here:
https://gazebo.sysexperts.com/~
On Mon, Apr 17, 2006 at 03:00:58PM -0400, Tom Lane wrote:
> I've applied a patch for this. On reflection, the CHECKPOINT during
> pg_start_backup was actually necessary for torn-page safety even without
> full_page_writes off. The reason is that the torn-page risk occurs when
> we write a page fr
Tom Lane wrote:
> You should at least show the page you think is corrupt.
I attempted to send this additional info to the list but I think the
message got dropped on the floor by the mailing list software or by
the spam filter.
I'll put the files on a web server and post links to them here.
--
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> I finally got around to looking at adding $PostgreSQL$ tags to all files
> in the repository.
Um, surely most of the ones that should have such tags already do.
(contrib might be a glaring weak spot.) We have explicitly decided
*not* to have tags in pl
I finally got around to looking at adding $PostgreSQL$ tags to all files
in the repository. To see what I was looking at, I ran the following on
a clean checkout:
find . -type f ! -path \*/CVS\* ! -exec grep -q '$PostgreSQL: pgsql' {} \;
-print
The results are at http://jim.nasby.net/no_cvs_tag.
Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> If we were to do this, I'd want some more-bulletproof mechanism for
> >> forcing full_page_writes on during the backup. We could probably
> >> keep a "backup in progress" flag in shared memory, and examine that
> >> along with the G
Bruce Momjian writes:
> Tom Lane wrote:
>> If we were to do this, I'd want some more-bulletproof mechanism for
>> forcing full_page_writes on during the backup. We could probably
>> keep a "backup in progress" flag in shared memory, and examine that
>> along with the GUC variable before deciding
* Martijn van Oosterhout (kleptog@svana.org) wrote:
> On Mon, Apr 17, 2006 at 12:24:40PM -0400, Stephen Frost wrote:
> > I certainly agree with all the rest but I'm just not sure I can agree
> > with you here. While s_tunnel is nice it's not always an option and I
> > think it *would* be nice to h
Tom Lane wrote:
> Bruce Momjian writes:
> > This is a much simpler fix than people talking about writing their own
> > backup programs.
>
> Well, it's still not exactly trivial. The hack that was being proposed
> involved having the admin manually do
>
> full_page_writes = ON (ie, edit co
[EMAIL PROTECTED] wrote:
> I was workin on the parser version 8.1.2 but wheneva simply update
> the date the compilation fails not even ne changes.
parse error
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
T
On Mon, Apr 17, 2006 at 08:07:23AM -0700, [EMAIL PROTECTED] wrote:
> Hi
> I was workin on the parser version 8.1.2 but wheneva simply update the
> date the compilation fails not even ne changes. but the same thing when
> done in 8.0.3 it works nicely.
What are you talking about? Please provide exa
On Mon, Apr 17, 2006 at 12:24:40PM -0400, Stephen Frost wrote:
> * Martijn van Oosterhout (kleptog@svana.org) wrote:
> > Seriously, if people want to do really sophisticated things with the
> > SSL library, they should setup s_tunnel instead. If we wanted to let
>
> I certainly agree with all the
Hi
I was workin on the parser version 8.1.2 but wheneva simply update the
date the compilation fails not even ne changes. but the same thing when
done in 8.0.3 it works nicely.
Pls help.
---(end of broadcast)---
TIP 9: In versions below 8.0, the pla
Bruce Momjian writes:
> This is a much simpler fix than people talking about writing their own
> backup programs.
Well, it's still not exactly trivial. The hack that was being proposed
involved having the admin manually do
full_page_writes = ON (ie, edit config file and SIGHUP)
* Martijn van Oosterhout (kleptog@svana.org) wrote:
> Seriously, if people want to do really sophisticated things with the
> SSL library, they should setup s_tunnel instead. If we wanted to let
I certainly agree with all the rest but I'm just not sure I can agree
with you here. While s_tunnel is
On Mon, Apr 17, 2006 at 11:25:26AM -0400, Tom Lane wrote:
> You're failing to consider async applications. AFAICS, the *minimum*
> API would be
> read
> write
> read ready?
> write ready?
> get socket so I can use it in select()
Actually, you only need two functions:
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > I have to agree with Martijn here too. It's not all that expensive to
> > provide read/write calls to abstract away the specific library being
> > used (since psqlODBC, at least, couldn't care less which library
> Come to think of it, someone not too long ago was proposing an API to
> allow a 'PITR slave' to subscribe to a master for WAL segments/changes;
> it seems logical to me for that API to also provide the ability to send
> relation data as well.
Is that what replication is for?
Joshua D. Drake
-
On Mon, Apr 17, 2006 at 11:07:26AM -0400, Stephen Frost wrote:
> I didn't really understand Tom's point here either... In order to not
> break psqlODBC when libpq is compiled with GnuTLS we'd have to code up
> support for returning an SSL* from the GnuTLS library that would work
> for all the Open
Tom Lane wrote:
> Bruce Momjian writes:
> >> Think harder: we are only safe if the first write to a given page after
> >> it's mis-copied by the archiver is a full page write. The requirement
> >> therefore continues after pg_stop_backup. Unless you want to add
> >> infrastructure to keep track
Bruce Momjian writes:
>> Think harder: we are only safe if the first write to a given page after
>> it's mis-copied by the archiver is a full page write. The requirement
>> therefore continues after pg_stop_backup. Unless you want to add
>> infrastructure to keep track for *every page* in the DB
On Sun, Apr 16, 2006 at 04:44:50PM -0400, Tom Lane wrote:
> > It seems that we should write an API to allow a backup device to ask for
> > blocks from the database.
>
> I don't think we have the manpower or interest to develop and maintain
> our own backup tool --- or tools, actually, as you'd at
Stephen Frost <[EMAIL PROTECTED]> writes:
> I have to agree with Martijn here too. It's not all that expensive to
> provide read/write calls to abstract away the specific library being
> used (since psqlODBC, at least, couldn't care less which library is
> being used, really)
You're failing to co
* Martijn van Oosterhout (kleptog@svana.org) wrote:
> The intention is not to provide access to everything. If people want to
> know more about the certificate, we simply export the certificate to
> them and they can do with it what they like, including sending it to
> another program. I wasn't exp
Martijn van Oosterhout writes:
> On Sun, Apr 16, 2006 at 05:29:04PM -0400, Tom Lane wrote:
>> No, failing to provide that is the bad idea, because then you're buying
>> into the notion that libpq will provide a universal API that will
>> incorporate anything anyone could possibly want to do with t
* Jonah H. Harris ([EMAIL PROTECTED]) wrote:
> I know we started a discussion a month or so ago regarding ideas for
> SoC projects. However, after reading through the thread, I didn't see
> us nail down any actual items.
I got an email already for a good idea, actually, which is to work on
having
Bruce Momjian writes:
> > I am thinking we should throw an error on pg_start_backup() and
> > pg_stop_backup if full_page_writes is off.
>
> No, we'll just change the test in xlog.c so that fullPageWrites is
> ignored if XLogArchivingActive.
>
> > Seems archive_command and
> > full_page_writes c
On Sun, Apr 16, 2006 at 05:29:04PM -0400, Tom Lane wrote:
> No, failing to provide that is the bad idea, because then you're buying
> into the notion that libpq will provide a universal API that will
> incorporate anything anyone could possibly want to do with the
> underlying SSL library. The abo
"Bruno Almeida do Lago" <[EMAIL PROTECTED]> writes:
> With the new tablespace scenario in mind, how do you see this check feature
> being implemented: as a script or inside the code?
I'd put it in the code, and share code somehow with the current check on
$PGDATA/PG_VERSION (maybe factor that into
OpenMFG has done some work on getting PostgreSQL working with the Drupal CMS
and the Mantis bugtracker (and also integrating those two, btw). We're in
contact with the respective projects about getting our patches worked in, but
if anyone's keeping a tally, just wanted you to be aware.
Regard
Hi
Anyone interested in plpython, please check out/review
http://archives.postgresql.org/pgsql-patches/2006-04/msg00087.php
It fixes the most obvious shortcomings of plpython by making it possible
to return both sets and records (and setof records) and to use named
input parameters in addition to
Tom,
With the new tablespace scenario in mind, how do you see this check feature
being implemented: as a script or inside the code?
As I said before, I apply for the creation of this patch. We just need to
decide the best way to implement it.
Regards,
Bruno Almeida do Lago
-Original Message
OK! I'll create a shell script to verify it.
If you change your mind latter I apply for developing the patch.
Best Regards,
Bruno
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 13, 2006 1:57 AM
To: Bruce Momjian
Cc: Bruno Almeida do Lago; pgsql-hackers
On Saturday 15 April 2006 22:33, Benjamin Arai wrote:
> Hi,
>
> Myself and a friend are PhD students at the University of California,
> Riverside. We would be interested in such a project if it were available.
> We are both experienced developers previously interning at EA Games and
> current syst
43 matches
Mail list logo