"Mohamed Fazil" <[EMAIL PROTECTED]> wrote
>
> Eg: If i have logged in as grook\gat (domain\username) and installed the
> database in this log in
> and start the database using mac12\postgre(domain\username) from the
> login grook\dat.
> The thing i want to know whether the process mentioned
Thank You. No, I had this doc already. Here it explains only how to install using an installer. What i am trying is to incorporate Postgres using the packages available in postgresql-8.0.5-binaries-no-installer.zip. I am able to start the database after the following conditions. 1. copied libpq.dl
"Dan Austin" <[EMAIL PROTECTED]> writes:
> One of Sun's kernel engineers has come up with a solution that seems to
> have fixed the problem. Instead of increasing work_mem (which we still
> might do) we've mounted a swapfs partition over the pg temp directory:
> # mount | grep pgsql_tmp
> /expo
> [...]
> Right, the file is fully written under a temp name, and then
> rename()'d
This makes sense and is almost certainly not the cause of the problem.
Although there is a lot more data being written to that file than I
would have thought.
One of Sun's kernel engineers has come up with a solu
You can very well get from the following
link.
http://www.postgresql.org/docs/8.1/interactive/largeobjects.html
- Original Message -
From:
Alain Rodriguez
Arias
To: pgsql-admin@postgresql.org
Sent: Friday, December 23, 2005 12:05
AM
Subject: [ADMIN] lo_ functions
Stephen Frost <[EMAIL PROTECTED]> writes:
> As I recall, the initial backup of our 360GB (or so) database took
> about 6 hours and the restore only took about 2 hours.
Really? I'd certainly have guessed the opposite (mainly because of
index build time, constraint checking, etc during reload). Co
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> ""Dan Austin"" <[EMAIL PROTECTED]> wrote
>> I take it that the file gets renamed almost immediately because we can
>> also see writes to the parent directory -- but never see the file itself
>> using ls.
>>
> I think so.
Right, the file is fully writt
""Dan Austin"" <[EMAIL PROTECTED]> wrote
>
> I take it that the file gets renamed almost immediately because we can
> also see writes to the parent directory -- but never see the file itself
> using ls.
>
I think so.
>
> /export/data/pgsql/data/base/64920741/pgsql_tmp/pgsql_tmp966.9
>
> What are
* Mike C ([EMAIL PROTECTED]) wrote:
> Yes, space is our limiting factor. A pg_dump archive format backup takes
> about 40mins for 25GB. A restore IIRC takes about 2 hours. However the size
> of the database is expected to grow to about 120 GB within a few months and
> by the end of 2006 over 400 GB
On 12/23/05, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote:> On 12/22/05, Simon Riggs <[EMAIL PROTECTED]> wrote:> On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:
> > All the documentation I've seen for PITR points to having to> do a
Tom,
Thanks for your reply.
> [...]
> > UID PID DBLOCK SIZE COMM PATHNAME
> > 103 687 W 120384 98304 postgres
> > /export/data/pgsql/data/global/pgstat.tmp.687
>
> Hmm. That's the stats collector creating a new current-stats file,
> which it does every half second or so
"Mohamed Fazil" <[EMAIL PROTECTED]> wrote
>
> i just forgot to remind you that i had tried to impliment no-installer
> PGSQL8.0 on Windows 2k,XP & NT.
>
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#2.1
Is that what you want?
Regards,
Qingqing
---
On Thu, Dec 22, 2005 at 10:35:43AM -0800, Alain Rodriguez Arias wrote:
> Where can I find examples of the use of the lo_ functions to load from or
> save to any file
Which ones? The client-side C/libpq functions, the server-side
functions available from SQL, or some third-party client or serv
Mike C <[EMAIL PROTECTED]> writes:
> I guess if pg_dump was modified to record the last complete transaction id
> (in archive format maybe) then the WAL files could be used?
No. pg_dump output and WAL files are at two utterly different levels of
abstraction --- the WAL files describe the exact pl
Mike C <[EMAIL PROTECTED]> writes:
> I need to create a new index on an existing table. The table is constantly
> inserted into every second. Does CREATE INDEX require an exclusive write
> lock on the table? If it does have a write lock what happens to the insert
> statements at the time, are they
On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote:
> On 12/22/05, Simon Riggs <[EMAIL PROTECTED]> wrote:
> On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:
> > All the documentation I've seen for PITR points to having to
> do a file
> > system copy of sorts.
>
On 12/22/05, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:> All the documentation I've seen for PITR points to having to do a file> system copy of sorts.Yes. There's no other way, but why would you want another way?
Mainly because a pg_dump backup takes up
I need to create a new index on an existing table. The table is
constantly inserted into every second. Does CREATE INDEX require an
exclusive write lock on the table? If it does have a write lock what
happens to the insert statements at the time, are they simply played
later or do they fail?
>From
Where can I find examples of the use of the lo_ functions to load from or save to any file
"Dan Austin" <[EMAIL PROTECTED]> writes:
> Solaris 10 has a tool called dtrace which reveals that pid #687 (a
> postgres backend) is doing a LOT of writing to a single file (iosnoop.d
> for you dtrace hackers):
> UID PID DBLOCK SIZE COMM PATHNAME
> 103 687 W 120384 98304 p
Martijn van Oosterhout writes:
> On Wed, Dec 21, 2005 at 11:30:15PM -0800, Benjamin Arai wrote:
>> Somebody said running "sync ; sync; sync" from the console. This seems
> The reason is partly historical. On some OSes running sync only starts
> the process but returns immediatly. However, there
Ok I'm using the EMS PostgreSQL Manager Pro utility to export my data into a XML, the thing is that when I got a bytea field, which i use to save files, when i tried to import the XML I have just create the file is corrupt.
I believe it has something to do with the XML encoding I'using or somethi
Hi , i just forgot to remind you that i had tried to impliment no-installer PGSQL8.0 on Windows 2k,XP & NT. Mohamed Fazil__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Hi, I had tried to implement the no-installer version of PGSQL8.0. Could you please send me the documentation/useful links that helps me to impliment PostgreSQL8.0 no-installer package. I would like to know whether Postgre SQL8.0 no-installer version can be implimented as a service or not. If possi
i want to execute a batch with 1000 statements.
is there any limit for number of statements or size.
please reveal.
On Wed, Dec 21, 2005 at 11:30:15PM -0800, Benjamin Arai wrote:
> I want to be able to do large updates on an existing backed up database
> with fsync=off but at the end of the updates how do I ensure that the
> data gets synced?
Do you know if that actually makes it much faster? Maybe you're bet
26 matches
Mail list logo
