Re: [ADMIN] doubt

2005-07-06 Thread Joshua D. Drake
Dong B. Calmada wrote: According to Joshua D. Drake: I don't show that as a package in my apt-cache? postgresql-autodoc is under the 'multiverse' category. Have you added the keyword to the sources.list's archive entry? Aha! I had universe not multiverse. Thanks for the tip. J -- Your P

Re: [ADMIN] doubt

2005-07-06 Thread Dong B. Calmada
According to Joshua D. Drake: > > I don't show that as a package in my apt-cache? postgresql-autodoc is under the 'multiverse' category. Have you added the keyword to the sources.list's archive entry? ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [ADMIN] doubt

2005-07-06 Thread Jonathan Daugherty
# I don't show that as a package in my apt-cache? It's in mine on debian testing. Redhat's package cache isn't nearly as extensive; I've found numerous widely-available packages missing from it, even ones you can get on redhat CDs. -- Jonathan Daugherty Lead Programmer Command Prompt, Inc

Re: [ADMIN] doubt

2005-07-06 Thread Joshua D. Drake
Dong B. Calmada wrote: According to Joshua D. Drake: Date: Wed, 06 Jul 2005 20:52:22 -0700 It depends on what you mean by Extend. If you mean adding contrib modules, custom functions etc... then just make sure that you have all of postgresql installed... libecpg-dev - development files for

Re: [ADMIN] doubt

2005-07-06 Thread Dong B. Calmada
According to Joshua D. Drake: > Date: Wed, 06 Jul 2005 20:52:22 -0700 > > It depends on what you mean by Extend. If you mean adding contrib > modules, custom functions etc... then just make sure that you have all > of postgresql installed... > > libecpg-dev - development files for ECPG (Embedded

Re: [ADMIN] installing postgres on solaris

2005-07-06 Thread Michael Fuhr
[Please copy the mailing list on replies so others can contribute to and learn from the discussion.] On Wed, Jul 06, 2005 at 08:40:10PM -0500, Mogin Mohandas wrote: > No..Im just downloading it from the website. So its from source. The > install 'read only' talks about the 'su' command which made

Re: [ADMIN] doubt

2005-07-06 Thread Joshua D. Drake
Mogin Mohandas wrote: Hi again I just wanted to know for extending the database, is it better to install postgres from a pre-installed package or source. I have installed ubuntu and was trying to install from source. Please give me some opinions. It depends on what you mean by Ext

[ADMIN] doubt

2005-07-06 Thread Mogin Mohandas
Hi again I just wanted to know for extending the database, is it better to install postgres from a pre-installed package or source. I have installed ubuntu and was trying to install from source. Please give me some opinions. Thank you Mogin ---(end of broadcas

Re: [ADMIN] installing postgres on solaris

2005-07-06 Thread Jonathan Daugherty
# > I am experiencing some problems installing postgresql on solaris # > machine. First of all , is it required that I be root at the time of # > configuring it because the commands seem to be for root. How do I # > configure if I am not the root. # # You typically do not need to be root to i

Re: [ADMIN] installing postgres on solaris

2005-07-06 Thread Michael Fuhr
On Wed, Jul 06, 2005 at 08:08:17PM -0500, Mogin Mohandas wrote: > I am experiencing some problems installing postgresql on solaris > machine. First of all , is it required that I be root at the time of > configuring it because the commands seem to be for root. How do I > configure if I am not

Re: [ADMIN] installing postgres on solaris

2005-07-06 Thread Joshua D. Drake
Mogin Mohandas wrote: Hi, I am experiencing some problems installing postgresql on solaris machine. First of all , is it required that I be root at the time of configuring it because the commands seem to be for root. How do I configure if I am not the root. You typically do not need to b

[ADMIN] installing postgres on solaris

2005-07-06 Thread Mogin Mohandas
Hi, I am experiencing some problems installing postgresql on solaris machine. First of all , is it required that I be root at the time of configuring it because the commands seem to be for root. How do I configure if I am not the root. Thank you Mogin ---(en

Re: [ADMIN] problem with WAL files

2005-07-06 Thread Jeff Frost
On Wed, 6 Jul 2005, Bruce Momjian wrote: That is strange. You said it reported the file did not exist. When the command fails, we assume it doesn't exist. Not sure what else we can do. I'm sorry, I should have copied and pasted the logs. It did not report a failure to copy from the archiv

Re: [ADMIN] problem with WAL files

2005-07-06 Thread Bruce Momjian
Jeff Frost wrote: > On Wed, 6 Jul 2005, Bruce Momjian wrote: > > > We basically run the command you give us via system(), so it is hard for > > us to know exactly why it failed. > > Understandable..but it would at least be nice to know that it failed. It > does > not appear to log anything at

Re: [ADMIN] problem with WAL files

2005-07-06 Thread Bruce Momjian
Jeff Frost wrote: > On Thu, 30 Jun 2005, Tom Lane wrote: > > > Jeff Frost <[EMAIL PROTECTED]> writes: > >> I'll have to retest that particular scenario and verify that something > >> else was not causing the problem when I have a chance now that I have > >> a fully functional and scripted out base

Re: [ADMIN] problem with WAL files

2005-07-06 Thread Jeff Frost
On Wed, 6 Jul 2005, Bruce Momjian wrote: We basically run the command you give us via system(), so it is hard for us to know exactly why it failed. Understandable..but it would at least be nice to know that it failed. It does not appear to log anything at this point. -- Jeff Frost, Owner

Re: [ADMIN] problem with WAL files

2005-07-06 Thread Jeff Frost
On Thu, 30 Jun 2005, Tom Lane wrote: Jeff Frost <[EMAIL PROTECTED]> writes: I'll have to retest that particular scenario and verify that something else was not causing the problem when I have a chance now that I have a fully functional and scripted out base backup and recover solution; however,

Re: [ADMIN] RPM for Fedora Core 1 on i586 hardware

2005-07-06 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 6 Jul 2005, vilson.farias wrote: does anyone know where I can get i586 RPMs for Fedora Core 1? My machine is still an i586. I've built the RPMs for you: http://developer.PostgreSQL.org/~devrim/fc1_8.0.3_i586/ Regards, - -- Devrim

Re: [ADMIN] RPM for Fedora Core 1 on i586 hardware

2005-07-06 Thread Joshua D. Drake
vilson.farias wrote: Greetings, does anyone know where I can get i586 RPMs for Fedora Core 1? My machine is still an i586. Recompile the source rpm. :) Sincerely, Joshua D. Drake [EMAIL PROTECTED] pg_rpm]# rpm -i postgresql-libs-8.0.3-1PGDG.i686.rpm package postgresql-libs-8

[ADMIN] RPM for Fedora Core 1 on i586 hardware

2005-07-06 Thread vilson.farias
Greetings,   does anyone know  where I can get i586 RPMs for Fedora Core 1?  My machine is still an i586. [EMAIL PROTECTED] pg_rpm]# rpm -i postgresql-libs-8.0.3-1PGDG.i686.rpm     package postgresql-libs-8.0.3-1PGDG is intended for a i686 architecture [EMAIL PROTECTED] pg_rpm]# uname -a

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Joshua D. Drake
Richard Doust wrote: Well, actually, (he said sheepishly) I deleted the WAL files myself. A bit of stupidity. Doh! In the future it would probably be wise to *not* do that ;) Sincerely, Joshua D. Drake On Jul 6, 2005, at 12:03 PM, Joshua D. Drake wrote: Richard Doust wrote: Thanks g

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Richard Doust
Well, actually, (he said sheepishly) I deleted the WAL files myself. A bit of stupidity. On Jul 6, 2005, at 12:03 PM, Joshua D. Drake wrote: Richard Doust wrote: Thanks guys. I didn't know about this command. It worked like a charm. Like I said, I had done a clean shutdown. If you did a

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Joshua D. Drake
Richard Doust wrote: Thanks guys. I didn't know about this command. It worked like a charm. Like I said, I had done a clean shutdown. If you did a clean shutdown and you lost those files you quite likely have a very serious problem. You should investigate your hardware. Files don't just "disap

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Richard Doust
Thanks guys. I didn't know about this command. It worked like a charm. Like I said, I had done a clean shutdown. Thanks again. On Jul 6, 2005, at 11:51 AM, Joshua D. Drake wrote: Richard Doust wrote: Hi. Can anyone please tell me what I can do? I've lost the contents of my pg_xlog director

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Bruce Momjian
Richard Doust wrote: > Hi. > Can anyone please tell me what I can do? I've lost the contents of my > pg_xlog directory and postmaster is failing to start because it can't > find a valid checkpoint record. It had done a clean shutdown, so I > know that the dbms should be okay if I could just r

Re: [ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Joshua D. Drake
Richard Doust wrote: Hi. Can anyone please tell me what I can do? I've lost the contents of my pg_xlog directory and postmaster is failing to start because it can't find a valid checkpoint record. It had done a clean shutdown, so I know that the dbms should be okay if I could just restart i

[ADMIN] Desparate: Lost WAL files

2005-07-06 Thread Richard Doust
Hi. Can anyone please tell me what I can do? I've lost the contents of my pg_xlog directory and postmaster is failing to start because it can't find a valid checkpoint record. It had done a clean shutdown, so I know that the dbms should be okay if I could just restart it. I'm in a desparate

[ADMIN] libpqxx on windows

2005-07-06 Thread sandhya
Thank you When i tried it..I got error,i am sending it to you. pls see and if any of u knows how to rectify itkindly tell me,as it is very much required to proceed further . Pls find it below: F:\libpqxx-2.5.3.tar\libpqxx-2.5.3\win32>nmake /f libpqxx.mak ALL Microsoft (R) Program Main