As far as I am aware, you're right and they ARE mutally exclusive.
Cheers
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Dick Visser
Sent: 04 January 2012 08:26
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Cannot resto
ses show it.
cheers
-Original Message-
From: francescobocca...@libero.it [mailto:francescobocca...@libero.it]
Sent: 07 July 2011 09:29
To: French, Martin; pgsql-admin@postgresql.org
Subject: R: Re: [ADMIN] adminpack installation problem
Dear all,
i have i question about server status tool of pgad
Hi
You need to ensure you install into the database you specified as your
maintenance database in pgAdmin.
If you connect to a database called "live" but use "template1" as your
maintenance database, then you will need to install into "template1".
psql -U postgres template1 -f /usr/share/post
lto:scott.marl...@gmail.com]
Sent: 08 April 2011 08:47
To: French, Martin
Cc: Tom Lane; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Out Of Memory 8.1
On Thu, Apr 7, 2011 at 8:56 AM, French, Martin
wrote:
> Thanks for the info Tom.
>
> The table has been analyzed (somewhat repeatedly.
47
To: French, Martin
Cc: Tom Lane; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Out Of Memory 8.1
On Thu, Apr 7, 2011 at 8:56 AM, French, Martin
wrote:
> Thanks for the info Tom.
>
> The table has been analyzed (somewhat repeatedly...), with the stats
> target set at various limits.
f it, didn't take into consideration how difficult it would be to
process this amount opf data on a row by row data.
cheers
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 07 April 2011 15:26
To: French, Martin
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADM
nks…
Martin.
From: scorpda...@hotmail.com [mailto:scorpda...@hotmail.com]
Sent: 07 April 2011 11:20
To: French, Martin; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Out Of Memory 8.1
Have you tried moving the FROM ... WHERE ... into a sub-select? GROUP BY uses
HAVING, not WH
Hi All,
I am having problems with a query on 8.1 running on
RHEL 5.4
16GB RAM
Linux pgsql3 2.6.18-164.el5PAE #1 SMP Tue Aug 18 15:59:11 EDT 2009 i686
i686 i386 GNU/Linux
2 x Xeon X5650 (2.67GHz 6 Cores)
Disks are on PERC 6 controller in RAID 10
Postgresql.conf:
# - Memory -
shared_buffers = 32
Ravi,
To (attempt to) answer your questions:
1) does the custom archive format of pg_dump needs to be in a file (not
pipe) for the pg_restore to seek back &forth ?
Not to my knowledge.
I suspect that the windows "type" command is adding extra "header"
information to the file before
Have you tried a non redirect? It could be that the "type" command
mangles the file (MS software is good at this)
pg_restore -Fc -C -U postgres -w -d postgres C:\testdump
or even with standard redirect
pg_restore -Fc -C -U postgres -w -d postgres < C:\testdump
I've had some issues with pg_restore
Have you tried connecting to the standby?
If the standby is in progress, then it should refuse with a "Database
Starting message" IIRC. If this is the case, I'd say it's fine...
Until someone comes along and corrects me of course...
Cheers
-Original Message-
From: pgsql-admin-ow...@pos
Agree with Kevin on this one, a new base backup and essentially re-start
the log shipping from scratch. I try and keep at least the last 20-30
applied xlogs on the standby server before removing them, so i have
never seen this issue personally.
On our databases, I try to do a base backup at least
ave resulted to coding shell
scripts, or C programs that are bespoke to accomplish this, as I've yet
to find a tool that does this to my satisfaction levels.
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: 20 January 2011 04:41
To: French, Martin
Cc:
ers
Martin
From: Bradley Holbrook [mailto:operations_brad...@servillian.ca]
Sent: 18 January 2011 16:57
To: French, Martin
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Postgres Backup Utility
Well, I can't just go dropping and recreating tables... it needs to
create the correct
I'm assuming that this needs to be tightly controlled and as such a
replication tool is out of the question?
In that case; The first thing to pop into my head here would be to use
either use shell scripting, or to use the pg API and write a c program
to handle it.
I remember doing something
15 matches
Mail list logo
