Geoffrey <[EMAIL PROTECTED]> writes:
> Shane Ambler wrote:
>> You would have two choices - clean up the data in 7.4 before the export
>> or clean up after the import and before the fk constraints are added.
> The latter is likely the plan. The primary concern is that we don't
> lose any data.
Shane Ambler wrote:
Geoffrey wrote:
We are trying to test our process for upgrading our database from
7.4.19 to 8.3.1. We are following the instructions for dumping the
7.4.19 database from:
http://www.postgresql.org/docs/8.3/static/install-upgrading.html
ie:
/usr/local/pg83/bin/pg_dumpall
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
We are trying to test our process for upgrading our database from 7.4.19
to 8.3.1. We are following the instructions for dumping the 7.4.19
database from:
http://www.postgresql.org/docs/8.3/static/install-upgrading.html
ie:
/usr/local/pg83/
David Rodríguez Canelón wrote:
I put the tablespace in a specific directory, but Postgre created a
copy of my database in de Postgre directory (C:\Archivos de
programa\PostgreSQL\8.2\data\base\10818), taking all my free space. I
need to know how i could set Postgre to create a database in a
difer
Geoffrey wrote:
We are trying to test our process for upgrading our database from 7.4.19
to 8.3.1. We are following the instructions for dumping the 7.4.19
database from:
http://www.postgresql.org/docs/8.3/static/install-upgrading.html
ie:
/usr/local/pg83/bin/pg_dumpall -h master -p 5434 |g
On Thu, 2008-05-01 at 09:57 -0400, Tom Lane wrote:
> AFAICS there is no convenient way in 8.1 to examine the per-database
> last_autovac_time entries, which'd be needed to confirm this theory.
> We should check that just to be sure. Please do the following:
>
> 1. Stop the postmaster.
> 2. Move t
Alvaro Herrera wrote:
Darren Reed wrote:
I saw this, but when I went in search of activity, there was nothing.
Look in:
http://sources.redhat.com/ml/rhdb/
http://sources.redhat.com/ml/rhdb-announce/
http://sources.redhat.com/ml/rhdb-cvs/
All of the archives for 2008 are empty...
It looks
Geoffrey <[EMAIL PROTECTED]> writes:
> We are trying to test our process for upgrading our database from 7.4.19
> to 8.3.1. We are following the instructions for dumping the 7.4.19
> database from:
> http://www.postgresql.org/docs/8.3/static/install-upgrading.html
> ie:
> /usr/local/pg83/bin/pg_
We are trying to test our process for upgrading our database from 7.4.19
to 8.3.1. We are following the instructions for dumping the 7.4.19
database from:
http://www.postgresql.org/docs/8.3/static/install-upgrading.html
ie:
/usr/local/pg83/bin/pg_dumpall -h master -p 5434 |gzip > dump.gz
Cr
Also check your DEP settings
- Original Message
> From: Scott Marlowe <[EMAIL PROTECTED]>
> To: Kranti K K Parisa™ <[EMAIL PROTECTED]>
> Cc: pgsql-admin@postgresql.org
> Sent: Thursday, 1 May, 2008 4:33:45 PM
> Subject: Re: [ADMIN] Urgent :: PostgreSQL on Vista Home Premium
>
> On Thu, M
am able to now. what i did is the following
: start > accessories > command prompt > right click on it > run as
administrator
then reach upto the postgresql msi file folder. run the file.
rest all is same.
cheers!
On Thu, May 1, 2008 at 9:01 PM, David Wall <[EMAIL PROTECTED]> wrote:
>
> I am
On Thu, May 1, 2008 at 9:12 AM, Kranti K K Parisa™
<[EMAIL PROTECTED]> wrote:
> Hi Guys,
>
> I am trying to install PostgreSQL on Vista Home Premium. Its giving me
> error.
>
> Can we install PostgreSQL on Vista Home Premium???
WARNING, you are about to receive advice on Windows Vista from a Unix
I am not able t install the PostgreSQL 8.3.1 version on windows vista
anyone tried the same? or have any suggestions?
We installed 8.3.1 on a Visa Home Edition laptop. I don't really recall
any issue. What happened to you? I know Vista prompts for all sorts of
things that you'll have to
Hi Guys,
I am trying to install PostgreSQL on Vista Home Premium. Its giving me
error.
Can we install PostgreSQL on Vista Home Premium???
--
Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625
This turned out to be a wrapper versus binary issue. psql was
running under the wrapper. It ran fine. pg_dump wasn't but when we
corrected this it worked fine too.
This is the first time I've run into this and it's the first time
I've dealt with PostgreSQL on any but a Sparc running Solari
Ian Westmacott <[EMAIL PROTECTED]> writes:
> I imagine if a database's last process time is in the future, that would
> mess up autovacuum's choice algorithm (at the least). Can I confirm
> this is the problem? Is there a way to fix it short of dump/restore?
Hmm, that would explain a lot wouldn'
Igniris Valdivia Baez wrote:
Hola
Soy estudiante de Ingeniería Informática. Le escribo porque consulté una
publicación suya en la web sobre POSTGRESQL y más específicamente mi duda es
sobre replica, tenemos un escenario de la siguiente manera, queremos montar una
aplicación para el país com
On Wed, 2008-04-30 at 16:43 -0400, Tom Lane wrote:
> Ian Westmacott <[EMAIL PROTECTED]> writes:
> 499 is the value that those columns would have immediately after initdb,
> in an 8.1 database. So what this says is that vacuum has never
> succeeded in updating the values at all, in any of your data
I put the tablespace in a specific directory, but Postgre created a copy of my
database in de Postgre directory (C:\Archivos de
programa\PostgreSQL\8.2\data\base\10818), taking all my free space. I need to
know how i could set Postgre to create a database in a diferent directory and
drive than
Hi,
I am not able t install the PostgreSQL 8.3.1 version on windows vista
anyone tried the same? or have any suggestions?
thanks in advance.
--
Best Regards
Kranti Kiran Kumar Parisa
M: +91 - 9391 - 438 - 738
+91 - 9849 - 625 - 625
On Tue, Apr 29, 2008 at 8:01 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Peter Koczan" <[EMAIL PROTECTED]> writes:
> > I'm going to try to force a crash on my test server to see if I can
> > find out anything more. Does anyone know how to get useful debugging
> > info at the time of the crash? I
21 matches
Mail list logo
