* Christopher Browne <[EMAIL PROTECTED]> [0223 20:23]:
> Clinging to sanity, [EMAIL PROTECTED] (Dick Davies) mumbled into her beard:
> > Is there a neat way to clean out a database via SQL commands?
> >
> > i.e. get rid of tables, sequences, integers, etc.
> >
> > At present I'm using dropdb/create
I am using 7.4.2 on Redhat 9 Linux 2.4. I know iam on old version, we
are actually planning to move to 8.0.1 soon, I just wanted to know if
this is bug if so if it is 7.4.2 related .
Tom Lane wrote:
Pallav Kalva <[EMAIL PROTECTED]> writes:
do you think this problem is specific to the 7.4.2
Pallav Kalva <[EMAIL PROTECTED]> writes:
> do you think this problem is specific to the 7.4.2
> version .
You didn't say what platform this is, but it might be related to this
7.4.3 fix:
2004-04-24 16:10 tgl
* src/backend/libpq/ip.c (REL7_4_STABLE): Ensure getaddrinfo_all
retur
Hi Tom,
Thanks! for the quick reply actually i forgot to attach the log file
in my first email, the next email has the attachment, anyways here is
the output from the log file. as you can see i have 5 numbers in the ip
address which was a typo and postgres crashes when it reads the hba file
[EMAIL PROTECTED] writes:
>Yesterday, our production database was crashed as soon as we added an
> invlid
> entry in the pg_hba.conf file. Immediately, after the SIGHUP it tried to read
> the pg_hba.conf file and it couldnt validate the IP address and restarted the
> postgres server, as soon a
On Wed, Feb 16, 2005 at 03:04:54PM +0100, Heiko wrote:
>
> I'm looking for a SQL command (SELECT) that returns me the
> access rights like the psql \z does. I can't find anything
> about it in the documentation. Thanks in advance...
Run psql -E or do a \set ECHO_HIDDEN -- that'll show the queries
Hi Everybody,
Yesterday, our production database was crashed as soon as we added an invlid
entry in the pg_hba.conf file. Immediately, after the SIGHUP it tried to read
the pg_hba.conf file and it couldnt validate the IP address and restarted the
postgres server, as soon as we change the pg_h
Hi,
I'm trying to create a trigger on PostgreSQL
it should be like an oracle(sql) sample code:
create or replace trigger frei_polygon_sync
after INSERT on frei_polygon
Referencing NEW as newROW
for each row
Begin
:newRow.objektid := :newRow.gid;
:
end;
Can sombody help me to do the same on P
On Mon, 14 Feb 2005 12:14:33 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Milen A. Radev" <[EMAIL PROTECTED]> writes:
> > The current value of my "listen_addresses" setting is:
> > listen_addresses = '192.168.0.1, 127.0.0.1'
>
> Nothing wrong with that.
>
> > but using "netstat -tupan" I still s
Hi list,
I'm looking for a SQL command (SELECT) that returns me the
access rights like the psql \z does. I can't find anything
about it in the documentation. Thanks in advance...
bye,
Heiko
--
To err is human, to forgive, beyond the scope of the (Operating) System.
Not running SELinux as it is behind a fire wall with only nated
connectivity.
Question is what folder or folders in /data need to be linked to /pgdata in
order to locate the data files, or if I stay with doing a initdb in /pgdata
what startup files needto be edited? Do I just use -D /pgdata then
"Joel Fradkin" <[EMAIL PROTECTED]> writes:
> I originally used the data_dir conf option to have my data on /pgslq/data,
> but am thinking I should do it the way I did the /wal with a link. My
> thinking is then the pid would still be in /var not /pgsql, and the stratup
> and shutdown would work bet
Morus Walter <[EMAIL PROTECTED]> writes:
> I guess the problem is, that he doesn't want to stop the database.
Yeah ... I'm afraid that's an impractical goal.
> I'd rather suggest to look into tablespaces.
> Create a new tablespace on some other filesystem and move the contents
> of the database b
I originally used the data_dir conf option to have my data on /pgslq/data,
but am thinking I should do it the way I did the /wal with a link. My
thinking is then the pid would still be in /var not /pgsql, and the stratup
and shutdown would work better.
I am reloading the server with Redhat AS 4 wh
Geoffrey writes:
> guly wrote:
> > I have installed postgresql in /usr/local filesystem on RH Linux. But
> > Running for two months,the datas are growing too fast.There is no enough
> > space at /usr/local filesystem. I want to make this filesystem bigger or
> > move the database to another
guly wrote:
> I have installed postgresql in /usr/local filesystem on RH Linux. But
> Running for two months,the datas are growing too fast.There is no enough
> space at /usr/local filesystem. I want to make this filesystem bigger or move
> the database to another
> filesystem and don't s
I have installed postgresql in /usr/local filesystem on RH Linux. But
Running for two months,the datas are growing too fast.There is no enough space
at /usr/local filesystem. I want to make this filesystem bigger or move the
database to another
filesystem and don't stop the database.Som
Hi Joel,
I'm running on a more or less similar hw config and my speed is pretty
ok.
My base is currently weighing in at 50Gig.
You may be having problems with the query itself. Aside from index'es
how you construct the query can have a dramatic impact on execution
time.
I can highly recommend th
18 matches
Mail list logo
