Dear all,
I am using postgres. when I try to connect to the database it is showing me
following error. Please look into that and help me out.
an error occurred:
FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database
"template1", SSL off.
How do I proceed with this error. Wh
On 2 Aug 2010, at 23:43, Radosław Smogura wrote:
>> PostgreSQL already has BIGINT aka INT8, which are 8 bytes, and can
>> represent integers up to like 9 billion billion (eg, 9 * 10^18).
> But I think about numbers with precision - you can use float for moneys, etc
> (rounding problems), and divi
On 08/02/10 3:49 PM, Hu, William wrote:
Each of the mobile POS when facing the consumer needs to process at
most 500 transactions a day. I was hoping to use the intermittent
network connection time to do system download to flag transactions,
such as, stolen credit card number, etc. And, to
Hi, I am designing a mobile POS application. I was hoping I can use the
Postgresql database as the central transactional database.
The application itself will run on a remote mobile PC. The retail
transaction data is small, it consists of the transaction timestamp,
location, amount, item pric
El 2 de agosto de 2010 19:14, John R Pierce escribió:
> On 08/02/10 7:35 AM, Felipe de Jesús Molina Bravo wrote:
>
>> Hi
>>
>>
>> I have installed postgres 8.4.4 (libxml and plperl)on a Sun Microsystems
>> sun4u Sun Fire 880 with:
>>
>> - 4 700Mhz processors
>> ...
>>
>> Also I have installed po
> how would you handle scale factors? numeric represents a BCD data
> type, with a decimal fractional component. how would you represent,
> say, 1.001 in your version? how would you add 1.001 to 1.01
> in your binary representation?
I think about datastructure something like this
[p
On 08/02/10 10:38 AM, stee...@gmail.com wrote:
Need some help to configure the WAl files shipping and restore it to the target server.here is what
I configured in the source server. (both windows)In postgresql.conf, I enabled the following
option.# WRITE AHEAD LOGfsync = on synch
Yes, that's me and it is for windows.
I enabled archive and copy WAL file, created base backup.
Restored base backup to target, removed files under pg-xlog, copy over archived
WAL files, for some reason recovery always look for WAL files from base
restore, not those archived WAL files.
--Or
On Mon, 2010-08-02 at 21:04 +, stee...@gmail.com wrote:
> Hi, I posted twice and didn't get any response, wonder my post didn't get
> populated properly.
>
> Again, followed the document on WAL shipping, and couldn't get target to
> recognize the archive WAL files. It looks for different WA
Hi, I posted twice and didn't get any response, wonder my post didn't get
populated properly.
Again, followed the document on WAL shipping, and couldn't get target to
recognize the archive WAL files. It looks for different WAL files.
Did I miss any steps?
Thx
Sent from my BlackBerry device on
2010/8/2 John R Pierce :
> On 08/02/10 7:35 AM, Felipe de Jesús Molina Bravo wrote:
>>
>> Hi
>>
>>
>> I have installed postgres 8.4.4 (libxml and plperl)on a Sun Microsystems
>> sun4u Sun Fire 880 with:
>>
>> - 4 700Mhz processors
>> ...
>> Also I have installed postgres (8.4.2) on a PC (Dell Opti
On 08/02/10 7:35 AM, Felipe de Jesús Molina Bravo wrote:
Hi
I have installed postgres 8.4.4 (libxml and plperl)on a Sun
Microsystems sun4u Sun Fire 880 with:
- 4 700Mhz processors
...
Also I have installed postgres (8.4.2) on a PC (Dell Optiplex 960)
with the next characteristics:
- 3 Gb
On 08/02/10 6:30 AM, rsmog...@softperience.pl wrote:
I would like to ask, about your opinion about numeric type. I implemented
binary read for numeric type in JDBC and I saw, that numeric type is stored
inside database as array of shorts no greater then nbase (currently 1).
In my opinion thi
Need some help to configure the WAl files shipping and restore it to the target
server.here is what I configured in the source server. (both windows)In
postgresql.conf, I enabled the following option.# WRITE AHEAD LOGfsync = on
synchronous_commit = on wal_sync_method = fsync
On Mon, 2010-08-02 at 14:35 +, Felipe de Jesús Molina Bravo wrote:
> Hi
>
> We design some performance tests (special for my application); this
> test was executed with pgbench:
>
> pgbench -c 5 -T 600 -n -U aeedc -f test.sql aeespc
>
You noted SCSI disks on solaris. They may not have th
Phil Dagosto writes:
> I am trying to use event notifications controlled by an ON UPDATE
> rule.
Rules don't work the way you are hoping --- in particular, the NOTIFY
will fire whether or not any individual rows get inserted. You might
have better luck using a trigger instead.
Hi all,
I'm new to Postgres and I'm not really a database expert but I was wondering
if someone could help me out with this issue.
I am trying to use event notifications controlled by an ON UPDATE rule. In
the table I'm interested in I have created a rule that should be invoked
when a particular
Registration for Surge Scalability Conference 2010 is open for all
attendees! We have an awesome lineup of leaders from across the various
communities that support highly scalable architectures, as well as the
companies that implement them. Here's a small sampling from our list of
speakers:
John
On Mon, Aug 2, 2010 at 07:30, wrote:
> Hello,
>
> I'm not member of this list, but because the 9th version of PostgreSQL is
> incoming, I would like to ask if there is possibility to add session
> property of application user
Not for 9.0 its more or less already cut.
> - this property, in contr
Hi
I have installed postgres 8.4.4 (libxml and plperl)on a Sun Microsystems
sun4u Sun Fire 880 with:
- 4 700Mhz processors
- 8 Gb Ram
- System 9 operSolaris
- 64-bit sparcv9 Applications
- 32-bit sparc Applications
- SCSI-3. Discs do not have any arrangement
It was compiled with the sun-studio
"Igor Neyman" writes:
> So, "backpatched to 8.4" - does it mean that we can expect new 8.4
> release (8.4.5) that will include these patches in near future?
> And if yes, then - when? Will it coinside with 9.0 release?
8.4.5 will be released whenever it seems appropriate (ie, whenever the
number
Hello,
This question mainly addressed to PG core developers.
Today in "PostgreSQL 9.0 Beta4 Released" article on postgresql.org I
read (amongst other things):
"Allow full SSL certificate verification when host and hostaddr are both
specified, backpatched to 8.4;"
There were similar notes ab
writes:
> I have migrated a 5 years old database from 8.1.21 running on top of centos
> 5.5 on an i686 to 8.4.4 running on top of centos on an x86_64 architecture.
> I have some nested views and i am still able to get the results on 8.1.21 but
> when it comes to 8.4.4, I can get the results onl
Hello,
I'm not member of this list, but because the 9th version of PostgreSQL is
incoming, I would like to ask if there is possibility to add session
property of application user - this property, in contrast to login name,
should be setted by driver (e.g. JDBC) to current user logged into
applicat
Hello,
I have migrated a 5 years old database from 8.1.21 running on top of centos 5.5
on an i686 to 8.4.4 running on top of centos on an x86_64 architecture.
I have some nested views and i am still able to get the results on 8.1.21 but
when it comes to 8.4.4, I can get the results only from vie
On Aug 1, 2010, at 4:44 PM, Jerry LeVan wrote:
> Has anyone looked at the feasibility of building libpq as a first step
> towards building
> An iPad app that can talk to postgresql dbs ?
Apparently, yes. http://www.spanware.com/iphonedb/MobileCan/MobileCan.html
ISTR someone discussing it on IR
On Fri, Jul 30, 2010 at 5:41 AM, Brad Nicholson
wrote:
> On 10-07-29 08:54 PM, Greg Smith wrote:
>>
>> Brad Nicholson wrote:
>>>
>>> Postgres also had a reputation of being slow compared to MySQL.
>>> This was due to a lot of really poor MySQL vs Postgres benchmarks
>>> floating around in the earl
27 matches
Mail list logo
