Re: [ADMIN] Pg_restore on 7.2 from 7.1 under cygwin

2002-03-12 Thread Oliver Elphick
On Wed, 2002-03-13 at 02:12, Don Saxton wrote: > The pg_restore seems to happily complete, although it doesn't end with > anything I could call a confirmation, except the return to cygwin prompt. > It's when I try to "psql gbap" and either \dt or select * from any table 'less' is a pager program

[ADMIN] Pg_restore on 7.2 from 7.1 under cygwin

2002-03-12 Thread Don Saxton
Having restored to 7.2 under cygwin from a 7.1 cygwin on another computer, I get this chilling response to \dt from psql: "less:not found", I had hoped for more... The pg_dump was pg_dump -b -Fc gbap | gzip > gbap.gz The pg_restore was gzip -c -d | pg_restore -c -d gbap -v I had created gbap

[ADMIN] client connection

2002-03-12 Thread Gill, Jeffrey L
I am trying to make my first connection from a client machine to a postresql server machine. What is the correct client command syntax to connect to the server? I do not want to attempt encryption yet so I am not using SSH or stunnel - I trying the easiest configuration i.e. telnet?. Specs: C

Re: [ADMIN] Admin software

2002-03-12 Thread W. McCloud
http://phppgadmin.sourceforge.net/ "W. Luijk" <[EMAIL PROTECTED]> wrote in message a5qa9v$142r$[EMAIL PROTECTED]">news:a5qa9v$142r$[EMAIL PROTECTED]... > I installed pg on a Redhat 7 box but dont know which tool > i can us to admininstrate (visual) the databases. > Can anyone help me? > > > -

[ADMIN] Postgresql 7.1 "No database files found"

2002-03-12 Thread Meaghan
Hi, We recently installed pgsql 7.1 on Mandrake 8.1, and did a pg_dumpall to import our old pgsql 7.0.2 databases. This morning, we tried to restart postgresql after a system crash, and we find that we suddenly have an error starting postgresql with the following message: [root@ocean home]# /et

Re: [ADMIN] Dependence beetwen Function

2002-03-12 Thread Stephan Szabo
On Tue, 12 Mar 2002, Dan Langille wrote: > On 12 Mar 2002 at 9:18, Stephan Szabo wrote: > > > > > On Tue, 12 Mar 2002, Gaetano Mendola wrote: > > > > > Hi to all > > > > > > Suppose that I have the function A that use the fucntion B. > > > When I drop and reconstruct B I should also reconstruct

Re: [ADMIN] Dependence beetwen Function

2002-03-12 Thread Dan Langille
On 12 Mar 2002 at 9:18, Stephan Szabo wrote: > > On Tue, 12 Mar 2002, Gaetano Mendola wrote: > > > Hi to all > > > > Suppose that I have the function A that use the fucntion B. > > When I drop and reconstruct B I should also reconstruct A. > > Can I avoid this ? > > Is a really problem with hun

[ADMIN] Installing contrib/tsearch

2002-03-12 Thread Jon Hassen
Hello, I am hoping that there is someone who has gone through the installation of the contrib/tsearch module who would be so kind as to instruct me as to what other things/modules/configurations are required for it to work properly. I'm pretty new to this and have been having a difficult time se

Re: [ADMIN] Dependence beetwen Function

2002-03-12 Thread Stephan Szabo
On Tue, 12 Mar 2002, Gaetano Mendola wrote: > Hi to all > > Suppose that I have the function A that use the fucntion B. > When I drop and reconstruct B I should also reconstruct A. > Can I avoid this ? > Is a really problem with hundreds of function around. If you're using 7.2 you can use creat

[ADMIN] Dependence beetwen Function

2002-03-12 Thread Gaetano Mendola
Hi to all Suppose that I have the function A that use the fucntion B. When I drop and reconstruct B I should also reconstruct A. Can I avoid this ? Is a really problem with hundreds of function around. Ciao Gaetano -- #exclude #include printf("\t\t\b\b\b\b\b\b");. printf("\t\t\b\b\b\b\b\b")

Re: [ADMIN] OIDs / noOIDs tables?

2002-03-12 Thread Tom Lane
Mathieu Arnold <[EMAIL PROTECTED]> writes: > ... there's a bit more info in the 7.2 database now... > so I believe that without oids give you a bit smaller databases. OIDs vs. no OIDs makes absolutely *zero* difference in disk space. The tuple header overhead is the same either way. (Well, okay,

Re: [ADMIN] OIDs / noOIDs tables?

2002-03-12 Thread Mathieu Arnold
--On lundi 11 mars 2002 08:10 -0800 Heni Lolov <[EMAIL PROTECTED]> wrote: > As for version 7.2 postgres supports tables wothout OID. So I have 10 Gb > database and I would like to upgrade it to 7.2 to make the tables without > oids in order to save disc space. I made a test. I created one table