Den 15. juli 2017 23:15, skrev Tom Lane:
> postgre...@get-experience.com writes:
>> I'm having a problem with the timetravel extension. Following simple schema:
>> ...
>> What am I doing wrong here? According to the function comment in
>> timetravel.c it should:
>> a) set last-version row to NEW d
Hey,
I'm having a problem with the timetravel extension. Following simple schema:
CREATE EXTENSION timetravel;
CREATE TABLE entries (
id SERIAL NOT NULL,
value INT NOT NULL,
valid_from ABSTIME NOT NULL,
valid_to ABSTIME NOT NULL,
PRIMARY KEY (id, valid_f
My best for all in this list.
i'm trying to use FDW for MongoDB
using PostgreSQL 9.4 using pgdg yum
repo: yum install
postgresql94-server postgresql94-contrib mongo_fdw94
My S.O. is CentOS
9.7 64bits
All is ok with Postgres. I can create extension, foreign
server and
foreign tabl
Thank you for your response. May i know what is the difference between log
shipping and streaming replication actually? I'm sorry i am very new in
postgreSQL and still confused with these two
__
If you reply to this email, your message will be added t
We have install PostgreSQL 9.3 in Ubuntu. We want to ask it is posibble to do
log shipping replication in one machine with different port such as port
5435 as a master while 5436 as a slave? We also tried that process in one
machine but still get an error in slave such as
warning: connection to
Hi!
I think there are dead links on this page.
http://www.postgresql.org/community/international/
These links cannot be accessed:
Chinese (Simplified) Simplified Chinese PostgreSQL Community
Chinese (Traditional) Traditional Chinese PostgreSQL Community
As of 1 May, 2013, I could not
On Wednesday, October 17, 2012 3:09 PM chinnaobi wrote:
> Hey Amitkapila,
>
> Thank you for the quick reply.
>
> How can implement this patch in windows, because I am using windows
> 9.1.1
> postgreSQL application ??
>
If the patch serves the feature you require, the
Hey Amitkapila,
Thank you for the quick reply.
How can implement this patch in windows, because I am using windows 9.1.1
postgreSQL application ??
___
If you reply to this email, your message will be added to the discussion below:
http
Dear PostgreSQL users,
I am very pleased to announce the release of the first issue of
PostgreSQL Magazine.
This issue #01 is brought to you thanks to the collective work of
dozen of people. Writers, Editors, Reviewers. Kudos to them all !
Here's a quick view of the ToC :
- PostgreSQ
2) If the creation of an aggregate function is the best option,
A) What is the highest performance language (or does it even
matter)? PL/C, PL/R, PL/pgSQL, other? Can one use pre-complied shared
libraries?
B) What is the best state function used to construct an array of
"Valu
Hello,
this fails with "duplicate key value":
CREATE TABLE x (
i INT NOT NULL UNIQUE
);
INSERT INTO x (i) VALUES (1), (2), (3);
UPDATE x SET i = i + 1;
are there any plans to make this work?
--
Roman Neuhauser
--
Sent via pgsql-general mailing list (pgsql-general@postgr
thanks,
hans
Oleg Bartunov wrote:
Hi there,
this is an announcement of our new contribution module for PostgreSQL
- Plantuner - enable planner hints
(http://www.sai.msu.su/~megera/wiki/plantuner).
Example:
=# LOAD 'plantuner';
=# create table test(id int);
=# create index id_i
- Original Message
From: Greg Smith <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Sunday, February 3, 2008 8:43:28 PM
Subject: Re: [GENERAL] Performance problems with Postgresql/ZFS/Non-global
zones on Solaris?
On
Thu,
31
Jan
2008,
Don't even bother trying to tune zfs untill after you've tuned postgres,
otherwise your wasting your time.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
As it turns out, I think the ZFS-on-RAID setup I had is the problem[1]. After
running some more
[Following up on my own message.]
>
Also,
> >
> let
> >
> us
> >
> know
> >
> your
> >
> wal
> >
> tunning
> >
> parameters
> >
> like
> >
> commit_delay,
> >
> fsync.
I haven't done any tuning as of yet. I'm running with the default settings
produced by initdb.
Bob
--
Mayuresh,
comments in-lined, below ...
- Original Message
> From: Mayuresh Nirhali <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, January 31, 2008 6:23:23 AM
> Subject: Re: [GENERAL] Performance problems with Post
In the hopes that someone has already blazed this trail ...
I'm running Postgresql (v8.1.10) on Solaris 10 (Sparc) from within a non-global
zone. I originally had the database "storage" in the non-global zone (e.g.
/var/local/pgsql/data on a UFS filesystem) and was getting pe
[EMAIL PROTECTED] a écrit :
Hi list!
I am using DBLink on a Win32 system running PostgreSQL 8.2 to query a table on
another similar system (Win32 / PostgreSQL 8.2).
If I query the server with dblink('hostaddr=ip_address ...', ...), it works
fine, but if I try to use the hostna
Hi list!
I am using DBLink on a Win32 system running PostgreSQL 8.2 to query a table on
another similar system (Win32 / PostgreSQL 8.2).
If I query the server with dblink('hostaddr=ip_address ...', ...), it works
fine, but if I try to use the hostname instead
(dblink
Ragnar wrote:
Reguardless of the issue whether pl/pgsql could be expected to
optimize this case, I find it difficult to imagine a scenario
where this kind of coding makes sense.
I understand that in some cases on would like to do this with
a *variable* to simplify logic, but what possible gain c
Tom Lane wrote:
[EMAIL PROTECTED] writes:
I would submit that in that situation, it would be
reasonable for a user to expect my suggested syntax to still use the
indicated indexes.
The only thing that will make that work is if "indexed_col IS NULL" were
an indexable condition, which it isn't
[EMAIL PROTECTED] wrote:
Tom Lane wrote:
you're still gonna lose because those are variables not constants ...
Well, that *is* what I'm hoping to do. I understand how (0 IS NULL) is
different from (variable IS NULL), but isn't it reasonable to expect
that PG could evaluate that expression o
Tom Lane wrote:
Well, you could update --- 8.2 contains code to recognize that the IS
NULL expression is constant, but prior releases do not.
That's excellent to hear -- I'd missed that in my perusing of the
changelogs between 8.0.x and 8.2. That does give me one more reason to
upgrade. It
Hello,
I've been using PostgreSQL for a few years and mostly love it. Aside
from a few (perceived, anyway) annoying limitations in PL/PGSQL (which I
almost exclusively am using for db interaction), I'm very satisfied with it.
I ran across this problem several months back and decid
Hi,
I'm interested in using postgresql_autodoc to document my postgres databases
on Linux, but I'm unable to find any information on how to install the
program or use it. Can someone point me in the right direction?
I've downloaded postgresql_autodoc-1.25.tar.gz from
http://www.rbt.ca/autodoc/re
> you should play around with phpPgAdmin for a while and let us know
> specifically what we can help you with.
I've managed to figure out how to fix most of my user access problems, but
I'm still having trouble limiting the list of databases users see when they
log in through phpPgAdmin.
I notice
Hi,
I'm hoping someone can tell me how to go about this, or if a solution is
even possible with my current set up. I realize this question may go beyond
pure postgres topics and have to do more with how my hosting company has
their servers configures, but this group seemed like my best option fo
Hi,
I'm looking for advice on how to update both structural changes and data
changes between PostgreSQL databases.
Here is my situation:
I have both a development and production environment. In the development
environment I have a PostgreSQL database that has many tables. Some o
Craig
> On Wed, 2005-10-19 at 08:23 +0200, [EMAIL PROTECTED] wrote:
>> Hi
>>
>> I am very new to FreeBSD (Windows Background), but am busy trying to
>> implement a PostgreSQL database that I have running in the Windows
>> environemtn on FreeBSD. Naturally, mos
Hi Sven
Thanks for the info. This is a great help.
One question:
> On Wed, 2005-10-19 at 08:23 +0200, [EMAIL PROTECTED] wrote:
>> Hi
>>
>> I am very new to FreeBSD (Windows Background), but am busy trying to
>> implement a PostgreSQL database that I have running in th
Hi
I am very new to FreeBSD (Windows Background), but am busy trying to
implement a PostgreSQL database that I have running in the Windows
environemtn on FreeBSD. Naturally, most of my problems so far have been
geeting to grips with FreeBSD.
Anyway, I am having a problem at the moment. Having
Hi
Suppose I have two databases on one server (lets call them DB_A and DB_B)
and I was to write a cross database query. How do I do this in PostgreSQL?
On MS-SQL I would do something like:
SELECT ta.Field1, ta.Field2, tb.Field2
FROM DB_A.dbo.SomeTable ta
JOIN DB_B.dbo.SomeOtherTable tb
ON
Hi
I am trying to get information about the Scalability options available for
PostgreSQL. Assuming you a database that has a huge volume of reads and
writes happening, what options have you got to scale your database. Many
commercial RDBMS' allow the clustering of Database servers and some
Hi
I am from a MSSQL background and am trying to understand something about
statistics in PostgreSQL.
Question 1:
In MSSQL, if you create an index (and you are using MSSQL's default
settings) the Server will automatically create appropriate statistics for
you. Does this happen in PostgreSQ
> [EMAIL PROTECTED] wrote:
>> Hi
>>
>> I come from a MSSQL background and am trying to figure out how to write
>> deployment scripts for PostgreSQL. Typically, if I want to drop a
>> function, I would write a script that first checks for it's existence
>
Hi
I come from a MSSQL background and am trying to figure out how to write
deployment scripts for PostgreSQL. Typically, if I want to drop a
function, I would write a script that first checks for it's existence and
then performs the drop.
In MSSQL it would be as easy as (this can be do
Hi Bruno
There are a lot of the topics that I feel could have better (or more
comprehensive examples). In particular I am thinking of plpgsql. One
example is information about working with Exceptions (postgresql specific)
and another is the small amount of info about the RAISE Statement
Hi
I am new to PostgreSQL and find that the standard documentation is very
thin. I would like to buy a more comprehensive book. All the available
books seem very out of date!!! Firstly, does it matter if I buy a book
that was published in Feb 2003? Will such a book be hopelessly out of
date
Hello,
Ive been working with PostgreSQL on Windows for
almost a year. But when I put it in production to the
customer it has had the following error after a power
cut:
invalid page header in block aaa of relation bbb.
in which aaa is a block number and bbb is a table.
Trying to find out
g
>> "record"
>
> If the function will always return the same row type then create a
> composite type with CREATE TYPE and return that instead of RECORD.
>
>> please can someone explain to me how to create a column definition list.
>
> See the documentation fo
hello,
I have read the documentation couple of times and I still can not figure out
the following aspects.
if a function does insert/update/delete it needs to be stable or volatile ?
if a immutable function executes 'nextval' should itself be also volatile ?
thanks,
Razvan Radu
I've started using pgpool and while everything appears to be working,
I've been getting a lot of the following errors in my logs:
ERROR: pid 14761: pool_read: EOF encountered
This seems to be simple enough - the client/user probably just canceled
the request and isn't anything to be conc
Basically, I'm looking for information on logging connections (who's
connecting and when), what the users are doing when connected (creating
tables, updating data, etc), and if there are any system messages (like when
the postgresql server is started, stopped, if it has problems, etc)
What logs does postgresql produce?
1) It has
transaction logs. Can it log connections? Are there other logs?
2) When I start
postgresql it outputs log messages to the console. Does this also log anywhere
else?
What I’m trying to do is find all the postgresql log
files and
You are probably going to use ODBC. I don't know if there are VB
drivers for postgresql. I have been using RealBasic on the mac and
there are drivers to directly access postgresql. Connecting is very
easy.
Check out the ODBC availability for VB.
Ted
-Original Message-
From:
What is the best way to import into a PostgreSQL database data from a
Microsoft Access database?
Should I export the data to a pipe or comma delimited file and then import?
*But how can I do that* ?
With mSQL it is easy, it has already a builtin function where you specify
the name of the text
46 matches
Mail list logo
