Re: [ADMIN] backup problem

2006-05-04 Thread Jyry Kuukkanen
On Thu, 4 May 2006, Rodrigo Sakai wrote: > Hi, I'm trying to do a backup of a database that is larger then 4 GB. But > it gets an error when the file size gets 1.2 GB! I think its an Operational > System problem (linux)! So, I want to know if exists some solution to backup > my database?? >

Re: [ADMIN] how to merge two databases

2005-11-10 Thread Jyry Kuukkanen
Hello On Thu, 10 Nov 2005, murali segu wrote: > i want to merge two databases how it is done plz help me > thanQ This should do the trick (under U*ix shell): pg_dump -U username -h hostname source_db | psql -U username -h hostname target_db -- --Jyry C|:-(C|:-/C|8-OC

Re: [ADMIN] backup

2005-01-08 Thread Jyry Kuukkanen
On Tue, 4 Jan 2005, Jimmy P Mani wrote: > hi > i have a backup of pgsql in .tar format > how can i make the database unzipped from that Hello It seems you use MS-Win based on "unzipped" word, hence I guess you should be able to unpack it using WinZip. In Linux/Un*x world, the command line optio

Re: [ADMIN] Any Gentoo users interested in a slotted PostgreSQL

2004-02-26 Thread Jyry Kuukkanen
Hello > Are there any Gentoo users here? Yes, there are some :) > Do you wish the PostgreSQL ebuild made use of SLOTS? > - to allow installing of major versions together (eg. 7.3 and 7.4 on the > same host) > - to ease migration of databases to new major versions (where a > dump/reload is r

[ADMIN] phpPgAdmin & PHP 4.3 problem sorted

2003-02-10 Thread Jyry Kuukkanen
Hello I think someone was wondering what was wrong with his setup under Suse 8.1 or something similar. I only realised, I had the same problem and I think it is due to phpPgAdmin's way of using register_globals in PHP. phpPgAdmin is now called WebDB (but will be called phpPgAdmin again befor

Re: [ADMIN] Sql Management Tool to download

2003-02-07 Thread Jyry Kuukkanen
I have used phpPgAdmin and have been pretty much happy with it. http://phppgadmin.sourceforge.net/ --jq On Wed, 5 Feb 2003 [EMAIL PROTECTED] wrote: > Hi, > > We are using postgresql for linux for the past 1 and half yr. > Our database gets increasing in no. of tables, datas ...etc. > We wa

Re: [ADMIN] Case Studio Postgresql

2003-01-14 Thread Jyry Kuukkanen
Hello Vida Luz Arista I am not quite sure what do you mean by your message. Do you want links or such of companies or goverments who are currently using PostgreSQL? Cheers, --jq On Tue, 14 Jan 2003, Vida Luz Arista wrote: > Hi, > > I am analyzing to Postgresql for e-goverment, nevertheless

Re: [ADMIN] problems dumping

2002-10-15 Thread Jyry Kuukkanen
On Tue, 15 Oct 2002, Andreas Schmitz wrote: > I have a problem dumping with 7.2.3. When I do a pg_dumpall redirecting this > to a file I have >4 lines of schema and data. Running psql template1 < > the databases get partially created, i.e the schema is completely > there but data even of

Re: [ADMIN] Lotus -> PgSQL

2002-07-09 Thread Jyry Kuukkanen
On Mon, 8 Jul 2002, Arnis Stasko wrote: > Is it posible to move data from Lotus to PgSQL. > If is then how? Hello I am not very sure what you mean by 'Lotus' which I think of as a software vendor, not a format or database or so. If you refer to Lotus Notes, I have to admit that I cannnot help

Re: [ADMIN] How to change datatype of a field

2002-05-26 Thread Jyry Kuukkanen
On Sat, 25 May 2002, Rajesh Kumar Mallah. wrote: > Hi Sreedhar, > > There are no commands as such but > combination of "CREATE TABLE AS SELECT f1,f2 from TAB" > and CAST might prove useful in certain cases > > > regds > mallah. > > On Saturday 25 May 2002 12:22 pm, shreedhar wrote: > > Is there a

Re: [ADMIN] no drop column?!

2002-03-24 Thread Jyry Kuukkanen
On Sun, 24 Mar 2002, Lucas Rockwell wrote: > bavc=> alter table staff drop column date_created cascade; > ERROR: ALTER TABLE / DROP COLUMN is not implemented > > is this true???!!! i am using PostgreSQL 7.2. > > -lucas Hello lucas Yes, it is true -- with Pgsql 7.3, too. There is a way to get

Re: [ADMIN] pg_dump max file size exceeded

2002-03-19 Thread Jyry Kuukkanen
On Tue, 2002-03-19 at 16:39, Fred Moyer wrote: > hey fellow pg'ers. > > ran time pg_dump -c --verbose database > datafile.psql from the command line > and got a file size limit exceeded. datafile.psql stopped at 2 gigs. any > ideas how to exceed that limit? > > redhat 7.2, 2.4.9-31 kernel > post

[ADMIN] Mergin a old dir with current system

2000-06-28 Thread Jyry Kuukkanen
Hi I've got a dir containing a valuable 6.5x db with one table, but I foolishly upgraded to 7.0 without pg_dumpall:in first. I tried going back to 6.53, vreated the db, then copied the backup to the place, but psql can't see the old table. Is there a way to merge the old stuff to newly created