On 7/17/13 10:40 AM, Nestor A. Diaz wrote:
Hello Nestor
I use its:
standby_mode = 'on'
primary_conninfo = 'host=X.X.X.X port=5432 user= password=YTT'
trigger_file = '/var/pgsql/data/pg_failover_trigger'
restore_command = 'cp /wal/%f /var/lib/postgresql/8.4/main/"%p"'
Ok, but those inst
>
>> Hello Nestor
>>
>> I use its:
>>
>> standby_mode = 'on'
>> primary_conninfo = 'host=X.X.X.X port=5432 user= password=YTT'
>> trigger_file = '/var/pgsql/data/pg_failover_trigger'
>> restore_command = 'cp /wal/%f /var/lib/postgresql/8.4/main/"%p"'
> Ok, but those instructions are for 9
> Hello Nestor
>
> I use its:
>
> standby_mode = 'on'
> primary_conninfo = 'host=X.X.X.X port=5432 user= password=YTT'
> trigger_file = '/var/pgsql/data/pg_failover_trigger'
> restore_command = 'cp /wal/%f /var/lib/postgresql/8.4/main/"%p"'
Ok, but those instructions are for 9.1 not for 8.4
> Hi Chiru, I have done archiving on primary server, and recovery on
> standby server, howerver, after the first recovery I am unable to
> recover more wal files on standby server
>
> Can it be possible in 8.4 ? or just in 9.1 ?
>
> This is the recovery I use:
>
> << EOF
>
> restore_command = '/u
On 07/17/2013 03:05 AM, chiru r wrote:
> Hi Nestor,
>
> So the question is: Can I have some continues wal archiving and then
> transfer all WAL files to *standby* everyday, recover the database and
> backup all data without having to rsync the data every time i make a
> backup ?
>
> Yes,You can d
Hello People,
I need some clarification on Continuous Archiving and Point-In-Time
Recovery (PITR).
I have been able to replicate a postgresql 8.4 database from one machine
to another using rsync and wal files.
I do this as follows (Using debian gnu/linux squeeze):
In *master* i have the followi
I have been using M$ Access for about 12 years now to create forms to update
postgresql data.
I use the postgresql odbc driver to establish a connection
There were a few issues to be worked out, for example getting Access and
postgresql to agree on how to handle boolean fields, how to fetch the k
Am trying to come up with a forms based front end (windows 7 localhost) to
enter and update a lot of data in several related tables within 9.1.
I have tried to install Postgres Forms (PFM), but the app won'tconnect to my DP
instance, it gives me a message that it: " couldn't execute psql.exe;
Glad to hear that you can spin up the database and get to your data.
Sorry to hear that you did end up losing data on that server.
-David Hornsby
On 1/19/2012 5:46 PM, Samuel Hwang wrote:
correct typo.
We pretty much lost the data for the last two days, but since our
postgresql wereN'T runnin
correct typo.
We pretty much lost the data for the last two days, but since our
postgresql wereN'T running well, it is fewer than it looks.
On Thu, Jan 19, 2012 at 3:45 PM, Samuel Hwang wrote:
> pg_resetxlog does the trick and db can be started and readable.
>
> I am dumping the data out and im
pg_resetxlog does the trick and db can be started and readable.
I am dumping the data out and import to a newly created database cluster.
We pretty much lost the data for the last two days, but since our
postgresql were running well, it is fewer than it looks.
Thanks a lot for the help.
On Thu,
> just nothing happened after that and postgresql is stuck at
> starting up and not getting out of archive recovery mode.\
What do you base that on? (copy/paste)
==> I have waited for at least 2 hours, but the database is still in
starting up state. In the mean time, there is not cpu/disk activi
Samuel Hwang wrote:
> I don't know how to make sure if WAL logs corrupted.
> At the end of the recovery in postgresql log I saw
>
> 2012-01-18 18:30:58.570 MST 3666 - LOG: consistent recovery
> state reached at 56C/CD0AFE00
> 2012-01-18 18:30:58.587 MST 3666 - LOG: recovery stopping
>
I don't know how to make sure if WAL logs corrupted.
At the end of the recovery in postgresql log I saw
2012-01-18 18:30:58.570 MST 3666 - LOG: consistent recovery state
reached at 56C/CD0AFE00
2012-01-18 18:30:58.587 MST 3666 - LOG: recovery stopping before abort
of transaction 54180204
Sounds like you have a corrupt wal files that you will have to reset the
wal logs with pgresetxlog.
http://www.postgresql.org/docs/8.2/static/app-pgresetxlog.html
This will result in missing transactions so before you do this shutdown
postgres and make a copy of the database files first. That way
Thanks, Rick.
I think we learned the lesson not to do kill -9. One weird thing was that
the three stuck automatically vacuum processes had been running for
probably more than a day and they were all working on the same pretty
static database. I doubt there were something wrong with our db. Howeve
version Postgresql 9.1.1 on centos5 x64
We experience slow performance and found the server is running 3 vacuum
process on the same db which use up 99% of CPU.
Then we kill -9 one of those process which cause postgresql to crash and it
tried to restart after the crash
However when the starting pro
Karuna Karpe wrote:
> Is postgresql store huge amount of data like oracle?
It's generally easier to respond to more specific questions. What
is "huge"? Our shop has a database of over 2 TB backing this web
site:
http://wcca.wicourts.gov/
I know there are PostgreSQL databases much larger
Hello sir,
I am fresher for working as DB-Admin and also beginner for
postgresql database. I have bit of knowledge about Oracle.
So, I have some of the questions about postgres. i.e. Is postgresql store
huge amount of data like oracle? Most organizations use oracle database, why
use p
Dave Pooser writes:
> On 7/3/11 10:33 AM, "Tom Lane" wrote:
>> Did you identify what it was that was linked to libldap_r?
> Not yet; it was 4AM at that point here in Dallas and I'd been beating my
> head against it off and on since 11AM. So I was too brain-fried to figure
> out how to identify t
On 7/3/11 10:33 AM, "Tom Lane" wrote:
>Did you identify what it was that was linked to libldap_r?
Not yet; it was 4AM at that point here in Dallas and I'd been beating my
head against it off and on since 11AM. So I was too brain-fried to figure
out how to identify the library and too exhausted t
Dave Pooser writes:
> On 7/2/11 8:50 PM, "Tom Lane" wrote:
>> Most likely what is happening is that one of the other libraries called
>> by the postmaster is pulling in libldap_r --- a bit of research with ldd
>> should confirm or deny that. If so, you could probably fix things by
>> hacking LDA
On 7/2/11 8:50 PM, "Tom Lane" wrote:
>Most likely what is happening is that one of the other libraries called
>by the postmaster is pulling in libldap_r --- a bit of research with ldd
>should confirm or deny that. If so, you could probably fix things by
>hacking LDAP_LIBS_BE in the configured sr
Dave Pooser writes:
> It seems there's some magic incantation to REALLY bind that I'm just not
> seeing here. Any help gratefully accepted.
Well, I don't know anything about Solaris either, but this bit looks
suspicious:
> root@testdb:/home/locadmin/postgresql-9.0.4# ldd
> /usr/local/pgsql/bin/p
>>
>>So I'm pretty sure that there *should* be a libldap_r.so someplace.
>>You could possibly try symlinking that to the version-numbered library.
>
>Yep, and I did that to get past the configure problems, which allows me
>to
>encounter a whole new problem in make :^)
That problem is that when I
Dave Pooser writes:
> On 7/2/11 7:16 PM, "Tom Lane" wrote:
>> The Oracle documentation avers that "-lldap" ought to be sufficient;
>> see for example ldap_simple_bind page in
>> http://download.oracle.com/docs/cd/E19963-01/pdf/821-1466.pdf
>> and even without that evidence it's hard to believe th
On 7/2/11 7:16 PM, "Tom Lane" wrote:
>> I'm pretty sure this is a Solaris-specific set of problems, starting
>>with
>> the fact that instead of libldap_r.so it's got libldap_r-2.4.so and the
>> configure script can't sort that out even though nm shows that
>> ldap_r-2.4.so does in fact have the f
Dave Pooser writes:
> OK, this is Solaris so there isn't an openldap-client or openldap-devel;
> there's only SUNWopenldap, which I installed.
Hmmm
> I'm pretty sure this is a Solaris-specific set of problems, starting with
> the fact that instead of libldap_r.so it's got libldap_r-2.4.so a
On 7/1/11 9:21 AM, "Achilleas Mantzios"
wrote:
>Looking in openldap-2.4.10/libraries/liblber/lber-int.h:94 i see :
>#define LBER_VALID(ber) ((ber)->ber_valid==LBER_VALID_BERELEMENT)
>the assertion fails for some reason.
>
>Could you make a proper reinstallation of the openldap related packages
>(
Looking in openldap-2.4.10/libraries/liblber/lber-int.h:94 i see :
#define LBER_VALID(ber) ((ber)->ber_valid==LBER_VALID_BERELEMENT)
the assertion fails for some reason.
Could you make a proper reinstallation of the openldap related packages
(openldap-client and possibly -devel),
remove the manua
TL; DR version: I'm trying to compile 9.0.4 on Solaris 11 Express and
having problems with LDAP support; I finally got it to compile and install
but when I try to authenticate via LDAP I get "Assertion failed:
LBER_VALID( ber ), file sasl.c, line 103, function ldap_sasl_bind" and it
kills the proce
Based on the below error message it looks like the Database and tables
already exists. Please check the database.
When you do a regular pg_dump, it won't include all the roles. You to
include roles have should always use pg_dumpall -l ( you can read up more
using #man pg_dumpall).
Good luck!
~De
I'm in some deep trouble here...
We've been running 8.1 on our CentOS 5 linux web server for many years.
Not having some of the features of 9.0 was starting to become a serious
issue, so I put in an order to the ServerPath data team to upgrade to
PostGreSQL 9.0
This worked, was a bit rocky
raha sadeghi wrote:
> i had active cube in template1; i mean i run cube.sql and there
> are cube functions in my databases but i don't know how to create
> cube!!!
> please help me and explain me how to do these kind of things step
> by step!!
Before anyone can make useful suggestions, I thin
hi,
i am a student , and for my final project i have to work with postgresql ;
my project subject is data warehousing & data mining, so i need to define
cube; create dimention table & fact table & ...
i had active cube in template1; i mean i run cube.sql and there are cube
functions in my databas
On Sat, Dec 5, 2009 at 3:46 PM, Guillaume Lelarge
wrote:
> Le samedi 5 décembre 2009 à 23:08:58, Andy Shellam (Mailing Lists) a écrit :
>> Hi Scott,
>>
>> >> 7. we can set the privilege of user x for schema y
>> >> ie. database aaa contains schema a1, a2 and a3. user xx can query from
>> >> sche
Le samedi 5 décembre 2009 à 23:08:58, Andy Shellam (Mailing Lists) a écrit :
> Hi Scott,
>
> >> 7. we can set the privilege of user x for schema y
> >> ie. database aaa contains schema a1, a2 and a3. user xx can query from
> >> schema a1 only, user yy can query from schema a2 only?
> >
> > No, p
Hi Scott,
>> 7. we can set the privilege of user x for schema y
>> ie. database aaa contains schema a1, a2 and a3. user xx can query from
>> schema a1 only, user yy can query from schema a2 only?
> No, perms on schemas control schema actions like create. perms on
> tables control user access.
On Mon, Nov 30, 2009 at 5:19 PM, Kiswono Prayogo wrote:
> hi, i've used postgresql for few months now, but i still don't understand
> about the schema/database part and it's security consideration..
> was there any better documentation (with pictures ^^) than
> this: http://www.postgresql.org/docs
hi, i've used postgresql for few months now, but i still don't understand
about the schema/database part and it's security consideration..
was there any better documentation (with pictures ^^) than this:
http://www.postgresql.org/docs/current/static/ddl-schemas.html
so, here's my current statement
> Subject: Re: [ADMIN] Help With Database Backup
> From: andy-li...@networkmail.eu
> Date: Wed, 30 Sep 2009 22:24:27 +0100
> CC: pgsql-admin@postgresql.org
> To: chal...@yahoo.com
>
> Hi,
>
> >
> > Hello there, I am new to PostgreSQL, succeded in running a
Hi,
Hello there, I am new to PostgreSQL, succeded in running a little
database on
my dev. machine and now I am having problems exporting the local
database to
the one I want to use on my site online. I am getting errors when I
try to
run the SQL online with phpPgAdmin.
What errors are
On Wed, Sep 30, 2009 at 6:38 AM, chalu wrote:
>
> Hello there, I am new to PostgreSQL, succeded in running a little database on
> my dev. machine and now I am having problems exporting the local database to
> the one I want to use on my site online. I am getting errors when I try to
> run the SQL
Hello there, I am new to PostgreSQL, succeded in running a little database on
my dev. machine and now I am having problems exporting the local database to
the one I want to use on my site online. I am getting errors when I try to
run the SQL online with phpPgAdmin.
I exported / backup the local d
Hi ,
I guess this is not Postgres.Is it Greenplum ?
Check for max connections on master and corresponding all nodes.
Max connections at nodes has to 4-5 times the max on master.
BTW are you using simple "create as select * from table " or anything else
Abhi
Hi ,
I guess this is not Postgres.Is it Greenplum ?
Check for max connections on master and corresponding all nodes.
Max connections at nodes has to 4-5 times the max on master.
BTW are you using simple "create as select * from table " or anything else
Abhi
John P Weatherman writes:
> I am intermittently seeing a job fail with:
> ERROR: Too many updates/deletes within transaction. Reader gang not able
> to provide correct visibility (combocid.c:270) (seg1 slice1 sdw1:50002
> pid=15588)
> SQL state: XX000
A bit of searching of the archives would've
All,
I am intermittently seeing a job fail with:
ERROR: Too many updates/deletes within transaction. Reader gang not able
to provide correct visibility (combocid.c:270) (seg1 slice1 sdw1:50002
pid=15588)
SQL state: XX000
Does anyone have any ideas what this really means? So far, waiting
until
First one, try to paste explain into http://explain.depesz.com/
> select
> a.id,
> ident_id,
> time,
> customer_name,
> extract('day' from timezone(e.name, to_timestamp(a.time))) as day,
> category_id
> from
> pwreport.url_hits a left outer join
> pwreport.url_hits_category_jt c on (a.id = c.url_h
Hi all;
we've been fighting this query for a few days now. we bumped up the statistict
target for the a.id , c.url_hits_id and the b.id columns below to 250 and ran
an analyze on the relevant tables. we killed it after 8hrs.
Any suggestions?
$ psql -ef expl.sql pwreport
Andrew Perrin wrote:
Greetings all-
Running postgresql under debian, my standard apt-get upgrade upgraded
me from 8.3 to 8.4. As a result, I no longer have access to the
databases that were created under 8.3.
Are you sure that 8.3 is really gone? Check around (look at what is in
/etc/init.d
Andrew Perrin wrote:
> 1.) Is there a way to "reconnect" the 8.3 server, after reinstalling
> it, to the raw files, so that the databases are there? I will then
> do a pg_upgradecluster and be happy; or, alternatively,
If you're in a hurry, just install 8.3 from source and run postmaster -D
/path
Greetings all-
Running postgresql under debian, my standard apt-get upgrade upgraded me
from 8.3 to 8.4. As a result, I no longer have access to the databases
that were created under 8.3. Typically I would use pg_upgradecluster to
fix this problem; however, the upgrade also removed 8.3, and so
On Thu, Sep 18, 2008 at 12:00 PM, Mauri Sahlberg
<[EMAIL PROTECTED]> wrote:
>> So, you built it its own machine, but you didn't upgrade to at least 8.2?
>>
>>
>
> Now it is: 8.4devel_15092008
I don't think I'd be running production data on a dev version of the
db. Not that it's likely to crash an
Hi,
The only other thing to check is what indexes are defined for
your schema. You can look at a previous post about PostgreSQL
indexing for RT to see what we are using here at Rice. Let me
know if you have any questions.
Cheers,
Ken
On Thu, Sep 18, 2008 at 09:00:14PM +0300, Mauri Sahlberg wrote
Hi,
Thanks for the reply and advice.
Scott Marlowe kirjoitti:
Version : 8.1.11Vendor: CentOS
So, you built it its own machine, but you didn't upgrade to at least 8.2?
Now it is: 8.4devel_15092008
The machine was installed by the production team from
On Tue, Sep 16, 2008 at 11:10:01AM -0600, Scott Marlowe wrote:
> On Tue, Sep 16, 2008 at 2:31 AM, Mauri Sahlberg
> <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > We just upgraded Best Practical's RT from 3.6 to 3.81 and gave the
> > database completely own machine. And the users still complain that it
On Tue, Sep 16, 2008 at 2:31 AM, Mauri Sahlberg
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> We just upgraded Best Practical's RT from 3.6 to 3.81 and gave the
> database completely own machine. And the users still complain that it is
> dog slow.
Moved up from below:
> Version : 8.1.11
Hi,
We just upgraded Best Practical's RT from 3.6 to 3.81 and gave the
database completely own machine. And the users still complain that it is
dog slow. :-( I installed pg_top and it seems that at the beginning of
the ticket display RT-issues a query that eats everything the database
has. Query i
On Thu, Sep 4, 2008 at 10:06 AM, Christian Larsen
<[EMAIL PROTECTED]> wrote:
> Hi! I have bought a WS 444 PC Weather Station.
> In order to use the device, a software called WeatherProfessional was
> included in the package.
> That software uses the postgresql service. I also got the PostgreSQL 8.
Hi! I have bought a WS 444 PC Weather Station.In order to use the device, a
software called WeatherProfessional wasincluded in the package.That software
uses the postgresql service. I also got the PostgreSQL 8.0with the package. My
problem is that I cannot get it to work properly.Firstly, if I
Igniris Valdivia Baez wrote:
Hola
Soy estudiante de Ingeniería Informática. Le escribo porque consulté una
publicación suya en la web sobre POSTGRESQL y más específicamente mi duda es
sobre replica, tenemos un escenario de la siguiente manera, queremos montar una
aplicación para el país com
Please keep responses on the list, I might not be able to get right
back to you, but someone else might... :)
On Tue, Apr 22, 2008 at 3:50 AM, Monalee Bhandge <[EMAIL PROTECTED]> wrote:
> Thanks for reply,
> Now my postgre server is running but as a client I
> can't connect to it.
> I apply al
On Montag, 21. April 2008 Monalee Bhandge wrote:
> I have Suse 10.2
rcpostgresql start
or
/etc/init.d/postgresql start
If you need to configure it, edit /etc/sysconfig/postgresql
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676/846 914 666
The Postgresql version which comes with Suse 10.2 actually is 8.2.6.
If there is no reason to downgrade I would recommend to use 8.2.6 or at least
the latest from the 8.1.x version which is 8.1.11 actually.
You did not write what package exactly you installed, but I assume it is not a
Suse RPM.
On Mon, Apr 21, 2008 at 3:18 AM, Monalee Bhandge <[EMAIL PROTECTED]> wrote:
> Dear,
> I am thinking to shift my software Axbo7.1 (see
> http://axbo.co.in/ )
> to postgresql from mysql.
> I have Suse 10.2 operating system in my organization.I
> install version 8.1.5-13 successfuly.
> but when
Dear,
I am thinking to shift my software Axbo7.1 (see
http://axbo.co.in/ )
to postgresql from mysql.
I have Suse 10.2 operating system in my organization.I
install version 8.1.5-13 successfuly.
but when I start server as>
pg_ctl start -D /var/lib/pgsql/data
then error is--
Chris Hoover escribió:
> When I do an "insert into test_a values (1,'a','test data');", does this
> generate 3 writes (1 to table, 1 to index, and one to oid counter) and one
> read (get oid from oid counter)?
No -- OID is in shared memory and updated "in batches" (i.e. once in a
while the serve
I need some help calculating how much activity a query causes.
If I have a table defined as:
create table test_a (
col1 integer,
col2 char(1),
col3 varchar(35),
primary key (col1,col2)
) with oids;
When I do an "insert into test_a values (1,'a','test data');", does this
generate 3 writes
>>> On Wed, Nov 14, 2007 at 4:08 PM, in message
<[EMAIL PROTECTED]>, "Cristiano
Marques" <[EMAIL PROTECTED]> wrote:
> I have necessity of integrate a data base
> Sybase and data base Postgresql. The propose is migration data of
> approximate 7000 tables.
>
> I like make cluster of two bases.
>
Listo.
_
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En nombre de Cristiano Marques
Enviado el: miércoles, 14 de noviembre de 2007 23:08
Para: pgsql-admin@postgresql.org
Asunto: [ADMIN] help to Brazil
Hello
My name is Marques, Cristiano. I have necessity of integrate a data
Hello
My name is Marques, Cristiano. I have necessity of integrate a data base
Sybase and data base Postgresql. The propose is migration data of
approximate 7000 tables.
I like make cluster of two bases.
Is possible?
Help me, please. Tks
select pg_database_size('km');
select pg_size_pretty(pg_database_size('km')) as size;
> Greetings,
> Can someone help me with the syntax for running a postgres function
> from the within psql? I need to know the size of several databases.
> The postgres documentation says there is a functi
You need to put the database name in single quotes:
select pg_database_size('km');
Regards,
Alex.
Carol Walter wrote:
Greetings,
Can someone help me with the syntax for running a postgres function
from the within psql? I need to know the size of several databases.
The postgres documentati
select datid from pg_stat_database where datname='km';
select database_size(that_id);
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carol Walter
Sent: Nov 13, 2007 9:35 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Help with comm
Greetings,
Can someone help me with the syntax for running a postgres function
from the within psql? I need to know the size of several databases.
The postgres documentation says there is a function that will do what
I need. The function is pg_database_size(name). I tried select
pg_da
On Nov 9, 2007 5:27 PM, joel zimmerli <[EMAIL PROTECTED]> wrote:
>
> I made a big mistake: I deleted the pg_log file and of course I've no backup
> of it. Now it seems I'm facing with big problem with my Postgres
> installation!
the pg_log directory on my machine just holds pg's log files. No big
I made a big mistake: I deleted the pg_log file and of course I've no backup of
it. Now it seems I'm facing with big problem with my Postgres installation!
Actually, I'm running Postgres on Cobalt Raq4 server and Postgres is used to
administrate virtual website definition.
As this is the "only"
from tab_temp
group by c1,c3,c4,c5
order by c1,c4,c5
select c3,c4,c5 from second_table order by c3,c4,c5
- Original Message
Da: Ben Kim <[EMAIL PROTECTED]>
To:
Cc: pgsql-admin@postgresql.org
Oggetto: Re: [ADMIN] HELP, can
If I understand you right I think what you want is
select c1,c2,c3,c4,c5 from table1 intersect select c1,c2,c3,c4,c5 from
table2
On 19/08/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I need to implement a filter in order to select from the first table the
> second one...
> it could
On 8/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi,
> I need to implement a filter in order to select from the first table the
> second one...
> it could be simple, but i'm wasting time. Please, is there anyone could help
> me?
> thanks in advance
> Giu
>
> c1 c2 c3 c4 c5
>
On Sun, 19 Aug 2007, [EMAIL PROTECTED] wrote:
Hi,
I need to implement a filter in order to select from the first table the
second one...
c1 c2 c3 c4 c5
1)133659;1;"0039";"00121";7
2)133664;1;"0039";"00121";12
3)133664;2;"0039";"00121";12
4)133665;2;"0039";"00121";12
5)135460;1;"0039
Hi,
I need to implement a filter in order to select from the first table the
second one...
it could be simple, but i'm wasting time. Please, is there anyone could help
me?
thanks in advance
Giu
c1 c2 c3 c4 c5
1)133659;1;"0039";"00121";7
2)133664;1;"0039";"00121";12
3)133664;2;"0039"
N KEY'
and tc.table_catalog = refc.constraint_catalog
order by prk.table_name , tc.table_name;
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Hoover
Sent: Thursday, August 16, 2007 11:19 AM
To: pgsql-admin@postgresql.org Admin
Subjec
I need a little bit of help. I need to use sql to pull any tables that have
the a foreign key referencing a given tables primary key.
So far I have come up with the listed query. It works great for single
column primary keys, but if a table has a multi column primary key, it is
returning to many
On Tue, Aug 07, 2007 at 05:09:35PM -0400, Chris Hoover wrote:
> We need some help, we have some what we believe are high value unicode
> characters (Unicode 0x2).
What do you mean by "high value unicode characters (Unicode 0x2)"?
Characters with code points in a plane other than Plane 0 (BMP,
Basi
We need some help, we have some what we believe are high value unicode
characters (Unicode 0x2). How can you search and replace for these? We are
storing this data in a text field, and having the data contain this unicode
value is violating our xml rules the application uses and causing abends in
On Fri, Aug 03, 2007 at 06:57:29PM +0600, ??? ? wrote:
> This quotation deals with receiving an inserts pack as 'plain text'. Well,
> well, but here we come to another problem: if a database is bulky, it 'does
> not want' to be loaded as plain text, and it requires choosing a
Hi to all,
I came across a problem while switching from 8.0 to 8.1.4 (or, now, to 8.2.4).
Here it is:
QUOTE: Some users are having problems loading UTF-8 data into 8.1.X. This is
because previous versions allowed invalid UTF-8 byte sequences to be entered
into the database, and this rel
On Tue, Jul 03, 2007 at 08:15:35AM +0800, Yuan HOng wrote:
> sites shall update these tables, and the link is over a WAN, it seems
> the most appropriate replication solution would be a multi-master,
> asynchronous solution.
Yes, that would be best.
> be to use a separate table for order on web s
[EMAIL PROTECTED] ("Yuan HOng") writes:
> It seems Slony-II would be quite promising, but I can't wait that
> long. What is the best choice for me now?
Worth noting: Slony-II would never have been suitable, as it would
have required that all the "master" servers be in the same data
centre.
I don'
Sorry I forgot the subject.
Hi, list,
Can you give me some suggestions as to what replication solution best
suits my situation:
I have an online product sales applicaiton, which is split between two
sites. The web front-end sits at the ISP's data center and accepts
customer order. The server in
Chris Hoover wrote:
I am doing some research into partitioning my postgres database.
While doing this, I am trying to take the opportunity to improve the
over all database.design. One of the things I am thinking of
implementing would be the use of nullif/coalesce. Our application
tends to s
I am doing some research into partitioning my postgres database. While
doing this, I am trying to take the opportunity to improve the over all
database.design. One of the things I am thinking of implementing would be
the use of nullif/coalesce. Our application tends to send a lot of strings
tha
Assuming the ERP software uses MD5 hashes to protect the password:
Since MD5 is a ONE-WAY encryption algorithm, then you *might* be able to
use a reverse lookup hash table such as the one found here:
http://gdataonline.com/seekhash.php
There may be similar hash tables around for other encryption
sufian khan wrote:
> How I decrypt any password that is store in our database table
> app_users.
That would seem to strongly depend on how you encrypted it in the first
place.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)--
Dear
I am using an ERP application. I am administrator of that application.
Actually I want to see the users passwords those are stored in encryption
format.
How I decrypt any password that is store in our database table app_users.
Regards
Muhammad Sufian Khan
Functional Consultan
On 8/28/06, Thomas Galla <[EMAIL PROTECTED]> wrote:
Hello everyone,Actually i'm working in a java project which attemps to storage oid data types in a postgres7.4.Anyway, when my application tries to store an oid, it throws a sqlexception that says:
ERROR: the column «doc_cidt» is of type oid but y
Hello everyone,Actually i'm working in a java project which attemps to storage oid data types in a postgres7.4.Anyway, when my application tries to store an oid, it throws a sqlexception that says:ERROR: the column «doc_cidt» is of type oid but yhe _expression_ is of type bytea
i'll give you my tha
Hi, in this moment I have a problem with my database, when i tried to access it, the administrator show me this message :
Error: cannot find attribute 10 of relation pg_am.
What can I do?.
Thanks.
1 - 100 of 380 matches
Mail list logo