[ADMIN] Novice question

Dear list Is is possible to copy /var/lib/pgsql from one computer to another and able login like the 1st computer? I have a production computer and a test computer. According to some literature, this can be done. However, I found that the database and user missing when use wiht psql. Curre

Re: [ADMIN] PG restore problem

"vidhya" <[EMAIL PROTECTED]> writes: > I am using postgresql 7.3.3 in win2k. > When we restore the database, the following error occurs and the Postgres c= > rashes immediately. > LOG: ReadRecord: unexpected pageaddr 0/FC1E6000 in log file 1, segment 5, > offset 1990656 Update to 7.3.4 or 7.3.5.

[ADMIN] Database size with postgres 7.2

I'm hoping to find a easy way to find the disk space used by each database on a given postgres v7.2 server - I've been looking through the docs and have seen some references to oid2name, but that doesn't really help my situation. Any suggestions? Robert Young ---(end of

Re: [ADMIN] Database size with postgres 7.2

Hi Robert I'm hoping to find a easy way to find the disk space used by each database on a given postgres v7.2 server - I've been looking through the docs and have seen some references to oid2name, but that doesn't really help my situation. This script gives you the used size per object. Unfortu

Re: [ADMIN] query

> Hi, > could you please let me know how to represent an image when creating a data > table using > postgresql Refer the documentation for details on lo_import and lo_export functions. It must help you. regards, bhuvaneswaran --- Disclaimer: http://www.bksystems.co.in/email-policy/disclaimer.t

[ADMIN] pgsql-admin

please forward 2004-01:[by date] [by thread] 2003-12:[by date] [by thread] many thanks ratnavale ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unr

[ADMIN] Oracle to PostgreSQL

We want to export a database from Oracle and we need to know informations about : - Tablespace - Memoryspace - Logical and physical space - Diskspace - How to make the export Thanks. ---(end of broadcast)--- TIP 9: the planner will ignore your desir

Re: [ADMIN] postgresql crushed with XLogWrite error

[EMAIL PROTECTED] (Andrew Sullivan) writes: > On Mon, Jan 05, 2004 at 07:35:16PM +0200, Tsirkin Evgeny wrote: >> On Mon, 5 Jan 2004 11:23:08 -0500, Andrew Sullivan >> <[EMAIL PROTECTED]> wrote: >> >> I want to keep my configs.Of course i can save my postgresql.conf >> (and other files that i chan

Re: [ADMIN] Database size with postgres 7.2

Oli Sennhauser wrote: Hi Robert I'm hoping to find a easy way to find the disk space used by each database on a given postgres v7.2 server - I've been looking through the docs and have seen some references to oid2name, but that doesn't really help my situation. This script gives you the used