Sorry the last message was for pgAdmin mailing list.
Pls. ignore it.
It was my type mistake and I am very sorry.
regards,
ivan.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/F
Hi,
I try to install the latest pgAdmin3 on my workstation.
It is running red hat 7.3.
I make the installation from source.
By running ./configure I got this message:
you must specify a valid pgsql instalation wit --with-pgsql=DIR.
I installed also the latest pg 7.3.4. ( I do not deen it on my
wor
Are you connecting on the local machine? If so try without the -U and -p
ex.: psql waterdb
You can also use telnet or ssh and connect from a remote machine and do
the same.
Kent N
On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote:
> I started postgresql with command:
> /etc/init.d/postgresql start
"Roberson, Dusty (L:ops Unix Admin)" <[EMAIL PROTECTED]> writes:
> make[4]: Entering directory
> `/hpux/database/postgresql-7.3.4/src/backend/utils/sort'
> cc -Ae +O2 -I../../../../src/include -c -o logtape.o logtape.c
> cc -Ae +O2 -I../../../../src/include -c -o tuplesort.o tuplesort.c
> cc: "
Ben Kim <[EMAIL PROTECTED]> writes:
> I compiled 7.3.4 on a host already running 7.2.1, with
> "--prefix=/different/directory --pgport=5833 ..." option.
> According to the installation instructions on
> developer.postgresql.org/docs/postgres/install-procedure.html, I thought I
> only have to give
I have Postgres 7.3.4 installed on a Slackware 9.0 system.
I start it from rc.local (/etc/rc.d/rc.local) with:
su postgres -c "/accounts/pg7.3.4/bin/pg_ctl -o '-i' -D
/accounts/pg7.3.4/data -l /accounts/pg7.3.4/logfile start"
Substitute the default location of your database which is usually
/usr
Hi,
is there a way to get a list of open cursors in a running backend ?
Thx
UC
--
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax:+1 650 872 2417
---
Please suggest how can we start the postgres from a remote machine. We are
using linux slackware as OS.
Deepti Chadha
Scientist B
Central Computer Facility
National Physical Laboratory
New Delhi
--
Open WebMail Project (http://openwebmail.org)
---(end of broadcast)
On another trial, I couldn't reproduce the problem, so I guess I could
have been mistaken about old binary overwritten by "make install". I would
like any advice, though, relating to the issue.
Thanks.
Ben
---(end of broadcast)---
TIP 9: the planne
HiPlease help
me...I am installing
postgresql-7.3.4 on solaris sparc 2.8.But
with make it is giving me the following error. I am strucked now.
Output:
make -C nbtree SUBSYS.omake[4]: Entering directory
`/opt/temp/postgresql-7.3.4/src/backend/access/nbtree'make[4]: `SUBSYS.o' is
up to dat
[EMAIL PROTECTED] (Chris Miles) writes:
> I've read a lot where people recommend using VACUUM FULL
> to free up disk space, especially after many updates/inserts.
>
> But does a regular VACUUM (or VACUUM ANALYSE) ever free up
> any space?
Yes, VACUUM surely can and does.
[extract from recent vacu
Hi,
I compiled 7.3.4 on a host already running 7.2.1, with
"--prefix=/different/directory --pgport=5833 ..." option.
According to the installation instructions on
developer.postgresql.org/docs/postgres/install-procedure.html, I thought I
only have to give a different directory as the --prefix,
I am trying to install postgres 7.3.4 on my B180L HPUX workstation.
I am having some problems getting the configure script to complete
properly.
It actually finished once or twice(not how I would like the configs) but
then the make failed.
The config errors are in the attached text document, and t
In my previous post,
> I intentionally used the same user name for both versions, only used a
> different directory. The two installations share the same PGDATA
> environment variable.
I want to clarify the above. I wanted to say "Although I have two versions
of postgres, because I have only one
I think you could choose between two solutions (at least) :
1 - Insert date and time in place of timestamp
2 - use some functions like substring. Something like :
select substring('09/12/2003 12:51:31.268 PDT' from '../../ ..:..:..')
Bruno
Shankar K wrote:
oops forgot to mention, database v
Folks,
i'm using postgres 7,3,2 on a debian (2,4 kernel),
but i cant get pam working to use a ldap server (which is not local),
is this a common error, or is it me?:)
i looked around, but didn't find an answer,
in the postgres log i can find that the connection is received,
in the messages log i
pginfo <[EMAIL PROTECTED]> writes:
> scott.marlowe wrote:
>> WAIT. Do you mean you get a kernel panic? Or the box locks up tight? Or
>> the box reboots?
> It is crashing the linux box. Not rebooting, not kernel panic, but only stop
> to respond.On the console if I type reboot it will not to reb
> does anybody know the internal pg_ tables that has table/column
> definitions defined (similar to user_tab_columns in oracle)
pg_class for tables.
pg_attribute for columns.
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 3: if posting/readin
scott.marlowe wrote:
> On Fri, 12 Sep 2003, pginfo wrote:
>
> > Hi,
> > I am runing linux red hat 7.3 (standart install)
> > on dual athlon box , 1 GB ram and pg 7.3.4.
> >
> > If I try to access with pgAdmin one from my tables (i contains ~ 1 M
> > records)
> > the linux box crashes.
>
> WAIT.
19 matches
Mail list logo