On 2/11/07, Benjamin Arai <[EMAIL PROTECTED]> wrote:
Hi Edwin,
Which connection parameters effect system resources?
i remembered wrong. the connection parameters i was thinking of is here:
http://www.postgresql.org/docs/8.2/static/libpq-envars.html
however, looking more closely to the config
Can anyone tell me if the win32 version of postgresql will install and
run on the 64 bit windows 2003 server? Will it work ok with ram > 4GB?
thanks
---(end of broadcast)---
TIP 6: explain analyze is your friend
I do not know about Windows server 2003, because I don't have it, but I DO
have the 64 bit version of Windows XP pro (and it seems to be much more
responsive that its 32 bit counterpart on the AMD Turion64 in my system),
and Postgresql works fine on it. As for the amount of memory, I have only
We recently migrated to a new server after having had the old one
running continously for over a year. The first night that we did a
backup, the file produced by pg_dumpall was noticably smaller than the
one we got from the old server prior to the switchover (2.5 GB versus
3.1 GB).
Is this s
Lewis Kapell <[EMAIL PROTECTED]> writes:
> We recently migrated to a new server after having had the old one
> running continously for over a year. The first night that we did a
> backup, the file produced by pg_dumpall was noticably smaller than the
> one we got from the old server prior to th
Sorry, I should have given the versions. The old server was running
8.0.8, the new server is running 8.2.1.
Thank you,
Lewis Kapell
Computer Operations
Seton Home Study School
Tom Lane wrote:
Lewis Kapell <[EMAIL PROTECTED]> writes:
We recently migrated to a new server after having had the
hi there
I lightly read this
http://www.postgresql.org/docs/8.1/static/backup-online.html
and am interested in creating an incremental backup of
WAL files, but my database is small so each of this
WAL files must be almost identical to the previous
one.
Is there a way to incrementally backup so t
Ted Byers wrote:
I do not know about Windows server 2003, because I don't have it, but I
DO have the 64 bit version of Windows XP pro (and it seems to be much
more responsive that its 32 bit counterpart on the AMD Turion64 in my
system), and Postgresql works fine on it. As for the amount of me
Hi,
On system startup PostgreSQL 8.1.4 refuses to start due to the pid
file is left over from previous "session" on Solaris 10 x86. After
removing the old pid file, PG start up and creates a new pid file:
[EMAIL PROTECTED] /# ls -l /var/opt/postgresql/data/postmaster.pid
-rw--- 1 postgres
Hi list,
I am curious becouse I am seen my postgresql locking the transactions when i
load a huge (in some case not to huge) numbers of records 70,000 records.
Could someone help me with it ?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
A
On Mon, 2007-02-12 at 11:43, Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> I am curious becouse I am seen my postgresql locking the transactions
> when i load a huge (in some case not to huge) numbers of records
> 70,000 records.
>
> Could someone help me with it ?
Are sure that what you're
I mean really deadlock. Other transactions can't access the database until
the main transaction is complete. A question:
PostgreSQL doesn't permit multiple transactions concurrently ?
Ezequias
2007/2/12, Scott Marlowe <[EMAIL PROTECTED]>:
On Mon, 2007-02-12 at 11:43, Ezequias Rodrigues da Roc
Ezequias Rodrigues da Rocha wrote:
I mean really deadlock. Other transactions can't access the database until
the main transaction is complete. A question:
PostgreSQL doesn't permit multiple transactions concurrently ?
PG has quite good concurrency behaviour. And "can't access the database"
i
2007/2/12, Richard Huxton :
Ezequias Rodrigues da Rocha wrote:
> I mean really deadlock. Other transactions can't access the database
until
> the main transaction is complete. A question:
>
> PostgreSQL doesn't permit multiple transactions concurrently ?
PG has quite good concurrency behaviour.
Ezequias Rodrigues da Rocha wrote:
2007/2/12, Richard Huxton :
Ezequias Rodrigues da Rocha wrote:
> I mean really deadlock. Other transactions can't access the database
until
> the main transaction is complete. A question:
>
> PostgreSQL doesn't permit multiple transactions concurrently ?
PG h
On Mon, 2007-02-12 at 12:08, Ezequias Rodrigues da Rocha wrote:
> I mean really deadlock. Other transactions can't access the database
> until the main transaction is complete. A question:
>
> PostgreSQL doesn't permit multiple transactions concurrently ?
Again, that's not a deadlock. A deadlock
This is delphi. I don't intent you understand but the sql actions are quite
simple (I am reading a list of numbers).
If not dm.database1.InTransaction then
dm.database1.StartTransaction;
For i:= 0 to memo1.Lines.Count - 1 do
Begin
// Catching ID
Ezequias Rodrigues da Rocha wrote:
This is delphi. I don't intent you understand but the sql actions are quite
simple (I am reading a list of numbers).
Well, let's see - the last Pascal I did was in 1986 I think...
If not dm.database1.InTransaction then
dm.database1.StartTra
On Mon, 2007-02-12 at 13:20, Ezequias Rodrigues da Rocha wrote:
> This is delphi. I don't intent you understand but the sql actions are
> quite simple (I am reading a list of numbers).
Hmmm. I'm not seeing anything in your example that should be blocking
other transactions. Is there anything tha
"Peter Kovacs" <[EMAIL PROTECTED]> writes:
> Please, could you tell me why the pid file is not deleted on shutdown?
It looks to me like the postmaster isn't being given enough time to
finish shutdown before being forcibly killed. This is not great,
but in theory we should always be able to recove
For what i understand, the WAL files only record changes to the database, so
each WAL segment is absolutely different from the previous one. As a matter
of fact, each WAL file is the incremental backup you want to make (provided
you have already taken a base or level 0 backup).
On Monday 12 Feb
What do you mean by indentical here? does it mean that they are same in
size, if that is true then yes they should be same in size unless you
specify archive_timeout (8.2 config parameter) setting to do a log switch
after certain amount of time.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
22 matches
Mail list logo
