My fear is that the tablespace is related to a specific directory of the OS;
and, in my best understanding on OS, the amount of memory of a directory is
bounded by the amount of memory of the related HD. Hence, when the amount of
memory related to such directory will run out of space it will not s
On Sat, Jan 12, 2008 at 12:39:52AM -0800, Antonio5556 wrote:
> My fear is that the tablespace is related to a specific directory of the OS;
> and, in my best understanding on OS, the amount of memory of a directory is
> bounded by the amount of memory of the related HD. Hence, when the amount of
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I must be blind or something but it seems I just can't
figure out a working procedure to restore a PG dump in
custom format (created with "pg_dump -Fc") into several
different PG databases with different owners (i.e. for
testing purposes)
I want
Hi all,
But surely if the rotation is disabled, PostgreSQL will just append to the
log if it exists (hence the extra option of "truncate on rotation?")
Many services use a single log file and just keep adding to it - that's the
way I'd prefer to set PostgreSQL up, simply so I can predict what the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
Just a short followup...
Andreas Haumer schrieb:
> Hi!
>
> I must be blind or something but it seems I just can't
> figure out a working procedure to restore a PG dump in
> custom format (created with "pg_dump -Fc") into several
> different PG d
Andreas Haumer <[EMAIL PROTECTED]> writes:
> I now solved it by temporarily adding the "superuser" privilege
> to the roles in question.
That should not be necessary, unless the dump contained objects that
require superuser permission to create (such as C-language functions)
--- in which case givi
"Andy Shellam" <[EMAIL PROTECTED]> writes:
> Many services use a single log file and just keep adding to it - that's the
> way I'd prefer to set PostgreSQL up, simply so I can predict what the log
> file's name is. Our rotation system will then rotate the log and keep the
> name in the same format
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Tom!
Thanks for your reply!
Tom Lane schrieb:
> Andreas Haumer <[EMAIL PROTECTED]> writes:
>> I now solved it by temporarily adding the "superuser" privilege
>> to the roles in question.
>
> That should not be necessary, unless the dump contained
Andreas Haumer <[EMAIL PROTECTED]> writes:
> Tom Lane schrieb:
>> Exactly what problems did you have using "-O -U user" ?
> So, the main problem is the call to
> CREATE PROCEDURAL LANGUAGE plpgsql;
> on the "mwdb" schema which contains all the tables, functions etc.
Right. As of 8.3, the default
Thankyou
Mmaybe it is off topic but is LVM available in Windows (xp?)? Or have I to
buy a specific tool? Which one?
Thanks
--
View this message in context:
http://www.nabble.com/physical-memory-tp14739957p14781197.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
-
> Mmaybe it is off topic but is LVM available in Windows (xp?)?
Yes.
> Or have I to buy a specific tool? Which one?
Just use the standard disk / volume management tools included under
Computer Management.
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemic
11 matches
Mail list logo
