[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.

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. This is

[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] 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.txt

[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

[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

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 changed and

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