On Fri, 22 Aug 2003, Vikram D. Gaitonde wrote:
One action we have consiously not done is REINDEX on the
table. We want to avoid that as far as possible.
Why do you want to avoid this? It may be the only option you have, other
than a database dump and reload.
3: relpages for the indices
I am sure many of you have encountered the problems I am experiencing
with automating the pg_dump command from a cron. The problem arises from
a failure of this command to use the environmental variable,
PG_PASSWORD. (PGUSER, on the other hand, is picked up during command
execution.) The cron
On Sun, 24 Aug 2003, Jesse Burkhardt wrote:
I am sure many of you have encountered the problems I am experiencing
with automating the pg_dump command from a cron. The problem arises from
a failure of this command to use the environmental variable,
PG_PASSWORD. (PGUSER, on the other hand, is
Hi, I would Like to get
information abort tables existing In PostgreSQL via? PHP. I would like to know the names,
their description and of course how they are build.
I Am not quite sure how to
get this on the Web Site, in PG I can use
?
\d table_name, but
it doesnt work here
Can
Hi List,
As I said before, I'm not a DBA yet , but I'm learning ... and I
already have a PostgreSQL running, so I have to ask some help...
I got a SQL as folows :
SELECT /*+ */
ftnfco00.estado_cliente ,
ftcofi00.grupo_faturamento ,
SUM( DECODE( ftcofi00.atual_fatura, '-',
well in unix man psql command line options -E shows the queries that are
generated by the \d or other sudo commands
reading a 10 point font on a 1600x1280 screen sucks, please text only to
mailing lists
--
Arno Karner aka Behind the Muffs
West 7th St., St. Paul aka smell, Minn
help
--
Petre Daniel,System Network Administrator.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi all!
Is it possible to make the postmaster re-read the pg_hba.conf when needed
without pg_ctl restarting the database? I think I could send a unix signal
to it, it would simly re-read the file and apply the information for new
incoming connection requests.
I was looking for this info in the
On Mon, 2003-08-25 at 08:17, Rhaoni Chiu Pereira wrote:
Hi List,
As I said before, I'm not a DBA yet , but I'm learning ... and I
already have a PostgreSQL running, so I have to ask some help...
I got a SQL as folows :
snip
I have created the decode, NVL and DIVIDE
On Mon, 2003-08-25 at 09:15, Hornyak Laszlo wrote:
Hi all!
Is it possible to make the postmaster re-read the pg_hba.conf when needed
without pg_ctl restarting the database? I think I could send a unix signal
to it, it would simly re-read the file and apply the information for new
incoming
[ADMIN] unsubscribe
_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
---(end of broadcast)---
TIP 1:
On Sun, Aug 24, 2003 at 00:38:35 +0800,
Chris M [EMAIL PROTECTED] wrote:
The link is very good. But another question.
In PostgreSQL, a superuser can modify almost everything in the
databases. But I don't think that should be the default. Maybe
adding an option is better. When a superuser
Bruno Wolff III [EMAIL PROTECTED]
This is usually accomplished by logging in as a normal user for most
tasks and only using a superuser account when it is needed.
Yes. DBAs should be careful when operating on the databases.
But I have seen many people using the superuser in MS SQL
Server to
Hi, I would Like to get
information abort tables existing In PostgreSQL via? PHP. I would like
to know the names, their description and of course how they are build.
I Am
not quite sure how to get this on the Web Site, in PG I can use
?
\d table_name,
but it doesnt work here
Can
I have had a lot of problems trying to install the postgres on a second
FreeBSD box. I installed it using the ports install, so that part of the
process went painlessly. however, when I tried to run the .sh script file
that was installed, I get nothing. The script's commands are:
chmod 600
At 03:46 PM 8/24/2003 , Jesse Burkhardt wrote:
One (non-trivial) solution is to use a cron (like fcron) that allows you to
set the environment of the executed process.
I like fcron very much, but you'd have to be the system administer (or his
cooperation) to install it.
I am sure many of you
One action we have consiously not done is REINDEX on the
table. We want to avoid that as far as possible.
Why? It's usually a very painless step, unless the table has millions and
millions of rows. We reindex tables with multiple indexes and several million
rows on a weekly basis. The only
Hi Folks
I am following the instructions in the techdocs for solaris 8 ( see
link below) and I am trying to
instal readline 4.2a first. It has not went well so far ...:-(
http://techdocs.postgresql.org/v2/Guides/Installation%20Guides/Compiling%20PostgreSQL%207.3.2%20on%20Solaris%208%209/view
I
On Fri, 2003-08-22 at 05:01, sharvari N wrote:
hello
How do i change the definition of a column? one of the columns width is
not sufficient to store the data. I want to change the width. how to do
that in postgres? I tried doing alter table + change/modify. both of
them doesn't work in
19 matches
Mail list logo