Skip site navigation (1) Skip section navigation (2)

migrating from linux to Windows

From: Gregor Novak <gregorn555(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: migrating from linux to Windows
Date: 2010-11-06 20:07:15
Message-ID: AANLkTikV6ED8ovefXL259nr9ObPEq69J=VAd-XB-a=ET@mail.gmail.com (view raw) 
Hello

I am new to PostgreSQL database. I have specific case regarding migrating
existing database from Linux to Windows. I am interested whether stored
procedures are compatible on Linux and Windows PostgreSQL. What is the
easiest way to migrate Tables and Data ?

Thank you for answering
Best  Regards, Gregor
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gregor Novak <gregorn555(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: migrating from linux to Windows
Date: 2010-11-07 00:15:30
Message-ID: 11959.1289088930@sss.pgh.pa.us (view raw) 
Gregor Novak <gregorn555(at)gmail(dot)com> writes:
> I am new to PostgreSQL database. I have specific case regarding migrating
> existing database from Linux to Windows. I am interested whether stored
> procedures are compatible on Linux and Windows PostgreSQL.

Sure.

> What is the
> easiest way to migrate Tables and Data ?

pg_dumpall.

			regards, tom lane

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group