On Mon, Mar 5, 2012 at 4:04 PM, Tom Lane wrote:
> Mike C writes:
>> I have been using table 17-2, Postgres Shared Memory Usage
>> (http://www.postgresql.org/docs/9.1/interactive/kernel-resources.html)
>> to calculate approximately how much memory the server will use. I'
Hi,
I have been using table 17-2, Postgres Shared Memory Usage
(http://www.postgresql.org/docs/9.1/interactive/kernel-resources.html)
to calculate approximately how much memory the server will use. I'm
using Postgres 9.1 on a Linux 2.6 (RHEL 6) 64bit system, with 8GB RAM.
Database is approximately
Hi,
I want to know if the "pg_restore -a" (data only, no schema) function
is a good method to restore data from a backup into an existing
database which already has data in its tables (and ensuring that
existing data is preserved).
I've done a simple test by backing up the database using pg_dump
Thank you both, this clears everything up for me.
Cheers,
Mike
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi,
Can someone clarify HOT updates for me (and perhaps put more detail
into the docs?). Is this statement correct: the HOT technique is used
on *any* table so long as no indexed column is affected.
create table T (A int, B int);
create index TB on T (B);
insert into T (A,B) Values (1,2);
So if
On 9/26/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> regression=# set timezone to 'Pacific/Auckland';
> SET
> regression=# select '2007-10-01 06:12:40.097244+12'::timestamptz;
> timestamptz
> ---
> 2007-10-01 07:12:40.097244+13
> (1 row)
>
> What have you got "
Hi,
I've just upgraded from Postgres 8.1.0 to 8.1.10 to update the NZ
timezone changes, but it doesn't seem to make a difference (I've also
patched linux). Ideas?
Below is how I'm testing (artificially set time into future):
-bash-3.1$ date
Mon Oct 1 07:12:36 NZDT 2007
-bash-3.1$ psql test
Welc
Title: php error
Hello,
Err message within a
browser(http://its-macman.otago.ac.nz/~mike/index.php) =
Fatal
error: Call to undefined function: pg_connect() in
/Users/mike/Sites/index.php on line 2
Actual code in php file =
$connection = pg_connect("host=its-macman.otago.ac.nz
dbname=ontheweb
