Where foo is a number of different tables, I'm calling
pg_dump --format=custom --compress=9 --no-password
--file=public.foo.pgdump --table=public.foo --schema-only my_database
When I check the contents of that dump using
pg_restore -l public.foo.pgdump
in some cases it includes the foo_id_seq o
On Tue, Oct 25, 2011 at 4:53 PM, Tom Lane wrote:
> Andrew Hammond writes:
> > On Tue, Oct 25, 2011 at 4:11 PM, Tom Lane wrote:
> >> Hmm, that's pretty interesting ... are there any nearby autovacuums of
> >> pg_toast_2619?
>
> > Several, both before
On Tue, Oct 25, 2011 at 4:11 PM, Tom Lane wrote:
> Andrew Hammond writes:
> > The following occur in the log file immediately before the
> > error message above.
>
> Hmm, that's pretty interesting ... are there any nearby autovacuums of
> pg_toast_2619?
>
Se
On Tue, Oct 25, 2011 at 2:20 PM, Tom Lane wrote:
> Andrew Hammond writes:
> > Oct 24 04:05:57 db-app02 postgres[24640]: [2-1]
> > user=nutricate,db=admin_production ERROR: missing chunk number 0 for
> > toast value
> > 2411466 in pg_toast_2619
>
> Hmm ... pg_t
I found the following error message in my logfiles.
Oct 24 04:05:57 db-app02 postgres[24640]: [2-1]
user=nutricate,db=admin_production ERROR: missing chunk number 0 for
toast value
2411466 in pg_toast_2619
Oct 24 04:05:57 db-app02 postgres[24640]: [2-2]
user=nutricate,db=admin_production STATEMEN
On 9/13/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> Alvaro Herrera wrote:
> > Bruce Momjian wrote:
> > >
> > > Is this item closed?
> >
> > No, it isn't. Please add a TODO item about it:
> > * Prevent long-lived temp tables from causing frozen-Xid advancement
> >starvation
>
> Sorry, I d
Does anyone know where I could find a tool which allows importing schema
information from a postgres database into visio? The boss guys want some
pretty pictures...
Andrew
On 4/9/07, CAJ CAJ <[EMAIL PROTECTED]> wrote:
On 9 Apr 2007 14:47:20 -0700, Andrew Hammond
<[EMAIL PROTECTED]> wrote:
> I'm writing a script that wants to know the latest release for a given
> major.minor version. Is there some better way than parsing
> http://www.pos
I'm writing a script that wants to know the latest release for a given
major.minor version. Is there some better way than parsing
http://www.postgresql.org/ftp/source/ or trying to connect to ftp
(which is invariably timing out on me today. Is that box getting
hammered or something?) and doing the
On Mar 6, 5:44 am, [EMAIL PROTECTED] (Kenneth Downs) wrote:
> Andrew Hammond wrote:
> > Each release will include a directory that has the same name as the
> > full release tag. This directory must contain all the scripts to be
> > applied.
>
> Have you considered usin
pment / maintenance. As a result I would like to both solicit
the input of the community and share the results. Documentation (which
is still somewhat drafty) follows.
Thank you for your time,
Andrew Hammond
Current Approach
A common problem in the database world is handling revisions to the
dat
On Feb 25, 9:34 am, [EMAIL PROTECTED] (Andrew Dunstan) wrote:
> Phani Kishore wrote:
>
> > hi !
>
> > i think u people could probably help me i how to query the
> > pgsql/postgis from google maps api to display the markers on the
> > google maps which are stored in the postgis database.
> > Phani K
12 matches
Mail list logo
