I have been searching for the ability for replication between postgresql database servers. Many of the solutions That I have seen either work only un*x or requires an expensive commercial license. I am looking something rather short term and maybe for a long term solution.
I came across this pro
On Fri, Jun 17, 2005 at 15:27:30 -0700,
Benjamin Smith <[EMAIL PROTECTED]> wrote:
> I wrote a rule a while back that, due to the software being extended, now
> needs to be deleted.
>
> How do I drop a rule?
>
> DELETE FROM pg_rules WHERE rulename='foo';
>
> doesn't seem to cut it...
On Jun 18, 2005, at 7:27 AM, Benjamin Smith wrote:
I wrote a rule a while back that, due to the software being
extended, now
needs to be deleted.
How do I drop a rule?
http://www.postgresql.org/docs/8.0/interactive/sql-droprule.html
DELETE FROM pg_rules WHERE rulename='foo';
doesn't
On Fri, Jun 17, 2005 at 03:27:30PM -0700, Benjamin Smith wrote:
>
> How do I drop a rule?
With DROP RULE. Here's a link to the documentation for the latest
release:
http://www.postgresql.org/docs/8.0/static/sql-droprule.html
If that doesn't work then please provide more info.
--
Michael Fuhr
I wrote a rule a while back that, due to the software being extended, now
needs to be deleted.
How do I drop a rule?
DELETE FROM pg_rules WHERE rulename='foo';
doesn't seem to cut it...
-Ben
--
"The best way to predict the future is to invent it."
- XEROX PARC slogan, circa 1978
Peter Fein wrote:
> On logging in from PGAdmin over SSL, one of my fellow developers gets
> the following message:
>
> Error column "sys" does not exist
>
> He can see a list of databases, but no schemas. I'm not able to
> replicate the problem. TIA.
Solved. From my coworker:
I checked "Syste
On 06/17/2005 07:49:07 AM, Együd Csaba wrote:
Hi,
we plan to make available our database from the internet (direct
tcp/ip
based connections). We want to make it as secure as possible. There
are a
few users who could access the database, but we want to block any
other
users to access.
Disclamer
On 05/26/2005 06:08:00 PM, Devrim GUNDUZ wrote:
Hi,
AFAICS from the user requests, many people is not aware about the
compatibility RPM we built:
http://developer.PostgreSQL.org/~devrim/compat-postgresql-libs-3-2PGDG.i686.rpm
is the compatibility RPM that fixes the problem which arose with
P
Együd Csaba wrote:
Dear Sean,
yes, maybe.
But actually I thought some suggestions. The only real problem of mine is to
configure the SSL. I am able configure the pg_hba.conf (at least I think so
now), we have a firewal on the server too.
I meant that maybe somebody can suggest something to m
Együd Csaba wrote:
Hi,
we plan to make available our database from the internet (direct tcp/ip
based connections). We want to make it as secure as possible. There are a
few users who could access the database, but we want to block any other
users to access.
Our plans are:
- using encripted (
On Fri, Jun 17, 2005 at 14:35:01 +0200,
Jose Gonzalez Gomez <[EMAIL PROTECTED]> wrote:
>
> The problem comes when you have questions that may be not applicable
> (8), or optional (doesn't know, doesn't answer) (9). The easy solution
> would be to have four tables:
>
> yes_no
> yes_no_not_applic
On logging in from PGAdmin over SSL, one of my fellow developers gets
the following message:
Error column "sys" does not exist
He can see a list of databases, but no schemas. I'm not able to
replicate the problem. TIA.
--Pete
--
Peter Fein [EMAIL PROTECTED] 77
I'm attempting to install PostgreSQL v8.0.3 on a Windows XP SP2 machine.
The error log below is generated and the installation rolls back. I
have verified that the "postgres" user (service account) has
read/write/execute permissions to the entire C: drive as well as having
the "logon as servi
Gavin Love wrote:
Here is the script I use for my daily backups nothing special but it
works well. Just run it as a user with admin privs on the database. It
will pull the list of all your databases except templates and dump
them out.
That is pretty neat! Here is Gavin's script slighty m
Ok.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Thursday, June 16, 2005 3:06 PM
Subject: Re: [GENERAL] pg_dumpall
On 16 Jun 2005 at 11:36, Zlatko Matic wrote:
Ok. but I have a problem. When i double-click, a black window appears,
prompting for pas
[EMAIL PROTECTED] ("Brandon Metcalf") writes:
> I've been looking at the auto vacuum daemon pgavd and it looks like
> there hasn't been any development activity in a while. Does anyone
> know that status of pgavd?
The pgavd "tarball" has not been touched since September 2002.
http://cvsup.de.op
[EMAIL PROTECTED] (Tino Wildenhain) writes:
> Am Montag, den 13.06.2005, 11:42 -0400 schrieb Chris Browne:
>> [EMAIL PROTECTED] (Tatsuo Ishii) writes:
>> >> For the contents too. I dont think the source code installation
>> >> should be so much in the focus of the certification.
>> >
>> > Since Po
Strange. I have successfully set the client encoding to BIG5 with
PostgreSQL 8.0.3 on Linux.
$ psql euc_tw
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or t
On 6/16/05, David Fetter <[EMAIL PROTECTED]> wrote:
> On Thu, Jun 16, 2005 at 07:54:29PM -, Greg Sabino Mullane wrote:
> >
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > I recently submitted a patch that makes all the database objects
> > behave in the same way as far as the back
You might know that our current handling of quoted strings is not SQL
compliant. In fact, we have a TODO item for it:
* Allow backslash handling in quoted strings to be disabled for
portability
The use of C-style backslashes (.e.g. \n, \r) in quoted s
Albert Vernon Smith <[EMAIL PROTECTED]> writes:
> I just re-checked, and all the same index definitions are on both
> tables.
Well, that seems to imply that the 8.0 planner is missing the plan that
7.4 finds ... which is both hard to believe and impossible to
investigate with this much info. Wo
"eblues" <[EMAIL PROTECTED]> writes:
> 1. Would like to try if you've ever successfully put Chinese characters
> into the so-called "Postgresql" databases. Their four support
> communities appear non-asian so far.
There is a very larqe and active PG community in Japan.
Unfortunately, I'm no expe
[EMAIL PROTECTED] writes:
> Hello,
>
> Having a great time with PG - ported an erp from oracle and db2. First
> I tried MySql but choked somewhere in the 900 table region. I have a
> python script to translate the syntax and it loads about 2000 tables.
>
> Now I want to COPY my dumps - I have 1 da
Együd Csaba <[EMAIL PROTECTED]> writes:
> Hi,
> we plan to make available our database from the internet (direct tcp/ip
> based connections). We want to make it as secure as possible. There are a
> few users who could access the database, but we want to block any other
> users to access.
Honestl
I'd use pg_dump anyway - unless you have hundreds of databases, it makes
it easier to keep by backups separate.
I will do that then. Thanks.
Here is the script I use for my daily backups nothing special but it
works well. Just run it as a user with admin privs on the database. It
will pull
I just re-checked, and all the same index definitions are on both
tables.
Cheers,
-albert
On 17.6.2005, at 14:20, Tom Lane wrote:
Albert Vernon Smith <[EMAIL PROTECTED]> writes:
I am in process of migrating a database from Pg 7.4.3 to Pg 8.0.3. I
dumped and reloaded the data, and things l
On Jun 16, 2005, at 12:32 PM, [EMAIL PROTECTED] wrote:
Hello,
Having a great time with PG - ported an erp from oracle and db2. First
I tried MySql but choked somewhere in the 900 table region. I have a
python script to translate the syntax and it loads about 2000 tables.
Now I want to COPY my
Albert Vernon Smith <[EMAIL PROTECTED]> writes:
> I am in process of migrating a database from Pg 7.4.3 to Pg 8.0.3. I
> dumped and reloaded the data, and things look good, until I try to
> work with it. When I try to make a query to a view based on a large
> join (select * from 'view' limi
stig erikson wrote:
when i try to do:
psql -l
psql: FATAL: database "template1" is not currently accepting connections
but if i first connect to some other database, ie:
psql -d database
\l
then it shows all the databases.
how can i resolve the issu with template1?
the problem might have
Jacob Atzen <[EMAIL PROTECTED]> writes:
> On Fri, Jun 17, 2005 at 01:21:13PM +0100, Richard Huxton wrote:
>> I'd use pg_dump anyway - unless you have hundreds of databases, it makes
>> it easier to keep by backups separate.
> I will do that then. Thanks.
Note that you probably also want to run "
Hello All,
PostgreSQL-8.0.3 doesnot work
with time zone value WAT0 ( for West Africa Time ).
HP Unix 11.23 PA and IPF servers set the time
zone value for West Africa Time as "WAT0" in it's "/etc/TIMEZONE"
file.
When we try to initialize the database directories
using initdb comman
On Fri, Jun 17, 2005 at 09:19:30AM +0200, stig erikson wrote:
>
> psql -l
> psql: FATAL: database "template1" is not currently accepting connections
Did somebody set datallowconn to false for template1? If you connect
to another database, what's the output of the following query?
SELECT datnam
Dear Sean,
yes, maybe.
But actually I thought some suggestions. The only real problem of mine is to
configure the SSL. I am able configure the pg_hba.conf (at least I think so
now), we have a firewal on the server too.
I meant that maybe somebody can suggest something to make the thing more
secu
On Fri, Jun 17, 2005 at 08:43:21AM -0400, Christopher Browne wrote:
> >> There is an option to pg_dumpall, -O, which makes it dump stuff
> >> without owners. See the following:
> > Ah yes, I should have told you that the server is running 7.4.5,
> > sorry. I will consider upgrading if there's no
when i try to do:
psql -l
psql: FATAL: database "template1" is not currently accepting connections
but if i first connect to some other database, ie:
psql -d database
\l
then it shows all the databases.
how can i resolve the issu with template1?
the problem might have been coused by a clie
Hello,
Having a great time with PG - ported an erp from oracle and db2. First
I tried MySql but choked somewhere in the 900 table region. I have a
python script to translate the syntax and it loads about 2000 tables.
Now I want to COPY my dumps - I have 1 data dump for each table. Any
tips on wha
1. Would like to try if you've ever successfully put Chinese characters
into the so-called "Postgresql" databases. Their four support
communities appear non-asian so far.
2. My problems is, although the 8.0 documentation (ch.14 pg. 292)
claims the conversion between EUC_TW and BIG5 is avalible, an
hi.
is there any encoding that does allow decimal placeholders in float8 to be
either , or .?
that is, it should allow both of the folling to denote for example EUR 12345 and
44 cents:
insert into table(my_float8_column) VALUES('12345.44');
insert into table(my_float8_column) VALUES('12345,44
Dear group,
We are using postgresql 7.4.7 on Fedora Core 3. We are currently
experiencing problems with running stored procedures on a database that
contains about 1200 tables. We have a table named adm_inst_mas with the
following structure
Table "public.adm_inst_mas"
Column |
On 16 Jun 2005 at 11:36, Zlatko Matic wrote:
> Ok. but I have a problem. When i double-click, a black window appears,
> prompting for password. But I can't input anything! Cursor is just
> blinking. I'm typing and nothing apears. If I click enter, pg_dumpall
> just closes... Postgres 8.02 is insta
I am in process of migrating a database from Pg 7.4.3 to Pg 8.0.3. I
dumped and reloaded the data, and things look good, until I try to
work with it. When I try to make a query to a view based on a large
join (select * from 'view' limit 10), the 7.4.3 query works very
well, and the indexe
On Jun 17, 2005, at 8:49 AM, Együd Csaba wrote:
Hi,
we plan to make available our database from the internet (direct tcp/ip
based connections). We want to make it as secure as possible. There
are a
few users who could access the database, but we want to block any other
users to access.
Our p
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Jacob Atzen)
wrote:
> On Fri, Jun 17, 2005 at 01:13:16PM +0100, Raymond O'Donnell wrote:
>> On 17 Jun 2005 at 13:52, Jacob Atzen wrote:
>
>> > The second problem is a matter of database ownership. Apparently
>> > pg_dumpall will dump th
Hi,
we plan to make available our database from the internet (direct tcp/ip
based connections). We want to make it as secure as possible. There are a
few users who could access the database, but we want to block any other
users to access.
Our plans are:
- using encripted (ssl) connections - sin
On Fri, Jun 17, 2005 at 01:21:13PM +0100, Richard Huxton wrote:
> What's the problem with creating a superuser called "postgres" on both
> machines? Or you could choose not to dump (or restore) ownership
> information (--no-owner). The section of the manuals you want is
> "PostgreSQL Client Appl
On Thu, Jun 16, 2005 at 10:32:46AM -0400, Tom Lane wrote:
> "Ilja Golshtein" <[EMAIL PROTECTED]> writes:
> > To be honest, I don't quite understand why PG does 'send' again and again,
> > while
> > EPIPE seems to be unrecoverable.
> > Isn't it better to terminate server process?
>
> No. See pre
Jacob Atzen wrote:
Hello list,
I have a setup with multiple databases running on one Postgres. Say,
db1, db2 and db3.
I have two problems with this setup, the first is how to restore one of
the databases and leave the other two intact. If for example somebody
accidentally deletes data from db1
Hi there,
I have the following problem: I'm developing some forms for data entry
for some clinical studies, with data stored on a PostgreSQL database.
The study is based in a questionnaire, with stablished options for
almost every question. They want answers to be stored as numeric codes
so they c
On Fri, Jun 17, 2005 at 01:13:16PM +0100, Raymond O'Donnell wrote:
> On 17 Jun 2005 at 13:52, Jacob Atzen wrote:
> > The second problem is a matter of database ownership. Apparently
> > pg_dumpall will dump the owners of the database along with the data.
> > This is causing trouble when I try to r
On 17 Jun 2005 at 13:52, Jacob Atzen wrote:
> The second problem is a matter of database ownership. Apparently
> pg_dumpall will dump the owners of the database along with the data.
> This is causing trouble when I try to restore the dump on a server where
There is an option to pg_dumpall, -O, wh
Hello list,
I have a setup with multiple databases running on one Postgres. Say,
db1, db2 and db3.
I have two problems with this setup, the first is how to restore one of
the databases and leave the other two intact. If for example somebody
accidentally deletes data from db1 which needs to be res
Hi,
thank you very much for suggestions. It seems to be OK.
I set the FSM related variables 200 times higher then the default values.
The database has been working stable for 3 days. Just as before, when the
databas was empty.
BTW, isn't it too high to increase these values to 200 times higher?
52 matches
Mail list logo
