Hi,
This is definitely off topic, I apologize.
We are planning to move our PostgreSQL installation from a shared
server to a dedicated server. I have been given the responsibility of
writing a migration policy document for this operation. This would be
my first such document to put together,
I am l
On 28 Jan 2012, at 15:27, "Greg Sabino Mullane" wrote:
>> Is this a case for multi master do you think?
>> I.e. running one on the internet, one locally.
>
> Yes, could be.
>
>> b) changing schemas (new tables, fields, views etc.) as well as data
>
> That's a tall order; I don't think anythin
On Saturday, January 28, 2012 1:29:22 am hubert depesz lubaczewski wrote:
> On Fri, Jan 27, 2012 at 03:11:32PM -0800, Adrian Klaver wrote:
> > Not sure that it makes a difference, but on the chance it does, what
> > are the options and are they the same for all machines?
>
> $ pg_config --configur
hubert depesz lubaczewski writes:
> is it by design that tables listed there (in extconfig column of
> pg_extension) will be dumped with data, even for pg_dump --schema?
Um, yes. Read the manual.
http://www.postgresql.org/docs/9.1/static/extend-extensions.html#AEN51966
r
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Is this a case for multi master do you think?
> I.e. running one on the internet, one locally.
Yes, could be.
> b) changing schemas (new tables, fields, views etc.) as well as data
That's a tall order; I don't think anything will do that a
On Saturday, January 28, 2012 1:43:43 am Bruno Boettcher wrote:
> On Fri, Jan 27, 2012 at 08:17:37AM -0800, Adrian Klaver wrote:
> > Did some digging. php-mktime returns the Unix epoch (seconds since
> > January 1 1970 00:00:00 GMT)
>
> indeed, didn't get it that postgres timestamp wasn't the same
On Fri, Jan 27, 2012 at 08:17:37AM -0800, Adrian Klaver wrote:
> Did some digging. php-mktime returns the Unix epoch (seconds since January 1
> 1970 00:00:00 GMT)
indeed, didn't get it that postgres timestamp wasn't the same
> Postgres has a function(to_timestamp) that will convert that to a
On Fri, Jan 27, 2012 at 08:03:06PM -0500, Tom Lane wrote:
> Do the command lines actually look exactly like that?
Yes. Exactly.
This is ubuntu, and --schema is parsed - more details in mail i sent
a minute ago as reply to Adrians mail.
Best regards,
depesz
--
The best thing about modern socie
On Fri, Jan 27, 2012 at 03:11:32PM -0800, Adrian Klaver wrote:
> Not sure that it makes a difference, but on the chance it does, what
> are the options and are they the same for all machines?
$ pg_config --configure
'--prefix=/opt/pgbrew/9.1.2' '--with-pgport=5910' '--enable-debug'
'--with-perl' '
James Robinson writes:
> ERROR: duplicate key value violates unique constraint
> "pg_toast_22608264_index"
> DETAIL: Key (chunk_id, chunk_seq)=(22354927, 0) already exists.
> The error is raised at the 'cluster' right after the commit.
This is probably the same issue reported as b
10 matches
Mail list logo
