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 indic
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 s
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, i
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 doesn’t 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
http://tnss.com/noi
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 doc
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 :
>
>
> I have created the decode, NVL and DIVIDE fu
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
> incom
[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: subscribe
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 super
"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
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 doesn’t 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 ${l
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 dow
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 p
19 matches
Mail list logo
