Re: [ADMIN] restoring template1

Roy Cabaniss <[EMAIL PROTECTED]> writes: > So how can I get the original template1 back from template0 DROP DATABASE; CREATE DATABASE. Note the comments in http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/managing-databases.html#MANAGE-AG-TEMPLATEDBS regards,

Re: [ADMIN] restore whoes

In article <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: >(2) On Unix machines, "text mode" I/O does not do anything different >from binary mode anyway. Our problem is with pg_dump data that has >temporarily left the Unix world and been munged in transit. We want >to be able to deal

[ADMIN] restoring template1

I inadvertantly wrote over the template1 file when I restored my data from a pgdump. So how can I get the original template1 back from template0 now that they name the files with numbers. It's gotta be something simple but I can't find it in the manual. -- Dr. Roy F. Cabaniss Associate

Re: [ADMIN] Is there a utility to load data?

pg_restore or copy. look in the documentation. I import data from flat files usually this way: psql dbname < file The file contains a line before the data: COPY "tablename" FROM stdin; data \. If your delimiter is something other than tab you must specify the delimiter type this way: COP

Re: [ADMIN] Is there a utility to load data?

Pam, I use the psql 'copy' function like this: copy from '' delimiters ','; Best regards, Chris At 14:00 -0500 02/13/2002, Pam Wampler wrote: >Is there a postgresql utility to load data from a flat file? Similar to >oracle sqlldr? > >---(end of broadcast)-

[ADMIN] Is there a utility to load data?

Is there a postgresql utility to load data from a flat file? Similar to oracle sqlldr? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [ADMIN] About Redo

No. The WAL files do not contain data to redo everything which was done to the database since day X. The WAL files contain data of current active transactions. In case the transaction aborts, the database will be returned to the stage it was in before the transaction started (aka Before Imagin

[ADMIN] Can you turn off the WAL on importing data?

Is it possible to turn off the logging while loading data into a "new" database? If so, how. and how do you turn it back on when the loads are finished? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] About Redo

Hello, I want to know the use of the transaction files in "pg_xlog". My concern is REDO such as ORACLE do. The following is our recovery method. I don't know whether it's possible or not. 1. Stop DB. 2. Clear the transaction files. 3. Save the directory "data" by tar command. 4. Start DB. : Somet

Re: [ADMIN] Number of connection

"Nebojsa Pirocanac" <[EMAIL PROTECTED]> writes: > How can I get number of current connections to the database and is there an= > y way to identify connection. For example in Oracle I can get these informa= > tion from dynamic view V$SESSION. In 7.2, yes. See http://www.ca.postgresql.org/users-lo

[ADMIN] Problem while connecting pgAdmin II v1.2

Hi, What version of PostgreSQL do you use? I sent a copy of your email to the pgAdmin-hackers list. Cheers, Jean-Michel ** Hi all, Thanks alot for response. I installed pgAdmin II v1.2. But while connection i am getting the following error. "An Error has occured in pgAdminII : frmConn

[ADMIN] Number of connection

Hi all,How can I get number of current connections to the database and is there any way to identify connection. For example in Oracle I can get these information from dynamic view V$SESSION. Thanks,Nebojsa.

[ADMIN] ALTER / DROP information for pgAdmin2

Dear hackers, Sorry to come back to ALTER /DROP object features, but I need some advice. 1) What we did in pgAdmin1 In late version of pgAdmin 1, we used to maintain two sets of objects : - one set of production objects (queried from PostgreSQL schema) including tables, views, triggers, etc..