> What are the correct steps to move an database and from an server
> running postgreslq 7.4.2 to another running 8.0.3?
I'll assume there are two hosts:
- db7, running 7.4.2, on port 5432, and
- db8, running 8.0.3 on port 5432.
The simplest method would be thus:
- Stop the applications access
If they are both up and running and reachable, then you likely just want to do
something as simple as:
pg_dumpall -h | psql -h template1
That's assuming you want to move all the DBs on the first server to the
second.
NOTE: pg_dumpall cannot dump large objects. If you have these, you'll ha
Then an easy way is likely to look at the init script that starts it, or use
ps auxwww |grep postmaster to have a look at how it was started. The last
command will likely yield something that looks like this:
postgres 3026 0.0 0.3 20064 3176 ?S08:21 0:00
/usr/bin/postmaster
Hello,
I have install
postgresql on Redhat AS 4.Now we want to migrate data from oracle 8i to
postgresql 8.1 and want to create snapshots , materialized
view,dblink,taking online backup,logical backup and establish
replication between three production server.Plz tell me which
documents,li
Hi,What are the correct steps to move an database and from an server running postgreslq 7.4.2 to another running 8.0.3?-- Richard Bortolucci
Hi,
My disk partition /var is full due to growing of postgresql DB.
I am using postgres DB for more than six months. After taking the backup I have to clean up all the DBs.(drop data only.This means table,DB structure must be maintained).Because, my data partition size is more that 90% in use
I'm using 7.4.8 so that does not work. Any other suggestions?
On Fri, 2005-12-16 at 15:50 -0800, Jeff Frost wrote:
> Run the following query:
>
> show data_directory;
>
>
> On Fri, 16 Dec 2005, Ken Hill wrote:
>
> > database, but I can find the directory where the database are kept. How
> > do
Run the following query:
show data_directory;
On Fri, 16 Dec 2005, Ken Hill wrote:
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consultin
Ken Hill <[EMAIL PROTECTED]> writes:
> How do I find where the postgresql database directory is from a command
> line?
Since 8.0 you can do "show data_directory".
regards, tom lane
---(end of broadcast)---
TIP 9: In versions
I installed postgresql using the Synaptic Package Manager on my Ubuntu
distro. I created the 'postgres' user account. I can create users and
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
You must add ...\PostgreSQL\8.1\bin\ to PATH manually and restart
;)
On 12/16/05, Ilias Goudaropoulos <[EMAIL PROTECTED]> wrote:
I am writing to you all just to inform you of a bug(probably), that Icame across while trying to install PostgreSQL 8.1.0-2 and 8.1.1-1 onWinXP with SP2, using the Postg
"Anjan Dave" <[EMAIL PROTECTED]> writes:
>> From where can I download a startup script for postgresql to put in
>> /etc/init.d?
> Check in the contrib directory of the source tree.
> Techdocs.postgresql.org site also has some to download I believe.
Also, the RPM distributions have one. If you al
Check in the contrib directory of the
source tree. Techdocs.postgresql.org site also has some to download I believe.
-anjan
From: Laureen Lampe
[mailto:[EMAIL PROTECTED]
Sent: Friday, December 16, 2005
12:01 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] startup scripts
From where can I download a startup script for postgresql to
put in /etc/init.d?
Thanks,
Laureen
. . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . .
Laureen Lampe
Database Administrator
Symyx IntelliChem
755
SW Bonnett Way, Suite 2100
Bend, OR 97702
I am writing to you all just to inform you of a bug(probably), that I
came across while trying to install PostgreSQL 8.1.0-2 and 8.1.1-1 on
WinXP with SP2, using the PostgreSQL installer.
I had done a windows clean install and then installed straight away
PostgreSQL 8.0.4. It was the only sof
-- Jorge Gabriel González B.Analista de SistemasPTI - Parque Tecnológico ITAIPU (www.pti.org.br / www.pti.org.py)Fábrica de Software
E-mail ([EMAIL PROTECTED]) ([EMAIL PROTECTED])Cel: +595 971 129941
hi.
I copied it using file streams.It worked fine for Linux even for
the remote Client.
But facing problems in Windows OS.I think it is not able to understand the
OID that we are passing.
It is giving error while opening the large object.
In Windows application how can i pass the larg
17 matches
Mail list logo
