> A customer of mine is running 8.3.8. We are attempting to
> take a backup, but whenever we issue pg_start_backup() it
> always says that we need to first run pg_stop_backup() - Even
> when I run the stop backup command right before trying to
> start the backup. I have restarted PostgreSQL a
Jayadevan M wrote:
> We have a PostgreSQL server with ASCII data. We have a
> requirement for the db to support UTF also. Which is the best
> approach -
> 1) Make a new installation, move data
This is the only and hence the best approach.
It doesn't have to be a new installation, a new databa
2009/12/23 Jayadevan M
> Hi all,
> We have a PostgreSQL server with ASCII data. We have a requirement for the
> db to support UTF also. Which is the best approach -
> 1) Make a new installation, move data
> 2) There is some way of doing an 'in-place' conversion and changing the
> character set o
Hi all,
We have a PostgreSQL server with ASCII data. We have a requirement for
the db to support UTF also. Which is the best approach -
1) Make a new installation, move data
2) There is some way of doing an 'in-place' conversion and changing the
character set of the existing installation
Please
Looks great. Thanks again! Robert
On 12/22/09 10:17 PM PST, "Christophe Pettus" wrote:
> Ah, you think you have all the links in an entry corrected... :) It's fixed
> now, thanks!
>
> On Dec 22, 2009, at 10:14 PM, Robert Hodges wrote:
>
>> Hi Christophe,
>>
>> Thanks for posting the vi
Ah, you think you have all the links in an entry corrected... :) It's
fixed now, thanks!
On Dec 22, 2009, at 10:14 PM, Robert Hodges wrote:
Hi Christophe,
Thanks for posting the video, but the linked video appears to be
Josh Berkus lecturing on GUCS, which I believe was the previous month
Hi Christophe,
Thanks for posting the video, but the linked video appears to be Josh Berkus
lecturing on GUCS, which I believe was the previous month.
BTW, since doing the Tungsten talk in early November we have also implemented
support for clusters using Londiste. We'll do some talks about it
The video archive for the 11/10 SFPUG meeting, "Continuent Tungsten
with PostgreSQL," is now available:
http://thebuild.com/blog/2009/12/22/sfpug-continuent-tungsten-with-postgresql/
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@po
On Tue, 2009-12-22 at 18:34 -0500, Francisco Reyes wrote:
> > Which os/distro are you looking for? I hope it is not Fedora 11 -
> > x86_64.
>
> CentOS x86_64
As written before:
http://yum.pgsqlrpms.org/8.4/redhat/rhel-5-x86_64/repoview/
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://w
On Tue, Dec 22, 2009 at 6:56 PM, Thomas ote:
> And could you give me some info about postgres internals? Such as
> ebooks or online articles.
I'm not sure if you've already reviewed this part of the PostgreSQL docs or not:
http://www.postgresql.org/docs/8.4/interactive/internals.html
--
Regard
On 12月22日, 下午11时26分, gryz...@gmail.com (Grzegorz Jaśkiewicz) wrote:
> On Tue, Dec 22, 2009 at 10:19 AM, Thomas wrote:
> > Does it write data to data files to make buffer "clean"?if it
> > does ,but I can not find open files from the result of lsof -p
> > PID.
>
> writer actually takes care about
On Tue, Dec 22, 2009 at 04:17:05PM -0800, Joshua D. Drake wrote:
- On Tue, 2009-12-22 at 16:08 -0800, David Kerr wrote:
-
- > - export PGPORT=5433
- > -
- > - etc...
- >
- > ok thanks, that might be an easier way to handle my scripts.
- >
- > can you export PGHOST as well?
-
- The manual prov
On Tue, 2009-12-22 at 16:08 -0800, David Kerr wrote:
> - export PGPORT=5433
> -
> - etc...
>
> ok thanks, that might be an easier way to handle my scripts.
>
> can you export PGHOST as well?
The manual provides a list:
http://www.postgresql.org/docs/8.3/static/libpq-envars.html
Joshua D. Dr
On Tue, Dec 22, 2009 at 05:01:45PM -0700, Scott Marlowe wrote:
- On Tue, Dec 22, 2009 at 4:57 PM, David Kerr wrote:
- > Howdy all
- >
- > I changed the default port for Postgresql.
- >
- > Now, when I want to access postgresql via psql (on the db server),
- > is there a way to make it default to t
On Tue, 2009-12-22 at 15:57 -0800, David Kerr wrote:
> Howdy all
>
> I changed the default port for Postgresql.
>
> Now, when I want to access postgresql via psql (on the db server),
> is there a way to make it default to the new port without using -p
> or a .psqlrc file?
>
Not that I know o
On Tue, Dec 22, 2009 at 4:57 PM, David Kerr wrote:
> Howdy all
>
> I changed the default port for Postgresql.
>
> Now, when I want to access postgresql via psql (on the db server),
> is there a way to make it default to the new port without using -p
> or a .psqlrc file?
You can set an envvar:
ex
Howdy all
I changed the default port for Postgresql.
Now, when I want to access postgresql via psql (on the db server),
is there a way to make it default to the new port without using -p
or a .psqlrc file?
I sort of assumed that psql connected via a local pipe and not a port.
Thanks
Dave
-
Thank you Jaime for your support.
I will ask the developers to check on
the software and locate which programs
are trying to access pg_autovacuum
catalog.
Also will try to create the
pg_autovacuum table.
Regards,
Antonio Sobalvarro
Soluciones Estrategicas S.A.
Avenida Reforma 6-39 zona 10
Edif
Devrim GÜNDÜZ writes:
On Tue, 2009-12-22 at 15:10 -0500, Francisco Reyes wrote:
Only up to 8.4.1 there.
Which os/distro are you looking for? I hope it is not Fedora 11 -
x86_64.
CentOS x86_64
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
On Tue, Dec 22, 2009 at 1:18 PM, Antonio Sobalvarro
wrote:
>
> This kind of programs get the error message “relation pg_autovacumm does not
> exist”.
>
what programs are failing?
anyway, the error is that those programs are accesing a catalog that
doesn't exist anymore (actually i consider an er
- "Dann Corbit" wrote:
> CREATE DOMAIN Nasty_Month_year AS CHAR(7)
> CHECK ( SUBSTR(VALUE, 1, 2) IN ('01', '02', '03', '04', '05', '06',
> '07', '08', '09', '10', '11', '12') AND SUBSTR(VALUE, 3, 1) = '.' AND
> SUBSTR(VALUE, 4, 4)::int BETWEEN 1980 and 2110 );
>
> CREATE TABLE foo (bar Nast
On Dec 22, 2009, at 16:11 , Scott Marlowe wrote:
alter table test add constraint test_a_check check (a ~
$r$^(0[1-9]|1[0-2]).(19[89][0-9]|20[0-9]{2}|210[0-9]|2110)$$r$);
However, I strongly recommend using a date column with, perhaps, a
restriction that the day field is always 1 or some other
On Tue, Dec 22, 2009 at 1:47 PM, Andrus wrote:
> Michael,
>
> Thank you very much.
> I have very few knowledge on rexexps.
>
>> CHECK (val ~ $re$^(19|20|21)[0-9]{2}.[01][0-9]$$re$)
>
> 1. I tried
>
> create temp table test5 ( tmkuu char (7) CHECK (tmkuu ~
> $re$[01][0-9].^(19|20)[0-9]{2}$re$) ) on
CREATE DOMAIN Nasty_Month_year AS CHAR(7)
CHECK ( SUBSTR(VALUE, 1, 2) IN ('01', '02', '03', '04', '05', '06',
'07', '08', '09', '10', '11', '12') AND SUBSTR(VALUE, 3, 1) = '.' AND
SUBSTR(VALUE, 4, 4)::int BETWEEN 1980 and 2110 );
CREATE TABLE foo (bar Nasty_Month_year );
This Works:
INSERT INTO f
Michael,
Thank you very much.
I have very few knowledge on rexexps.
CHECK (val ~ $re$^(19|20|21)[0-9]{2}.[01][0-9]$$re$)
1. I tried
create temp table test5 ( tmkuu char (7) CHECK (tmkuu ~
$re$[01][0-9].^(19|20)[0-9]{2}$re$) ) on commit drop;
insert into test5 values('01.2009');
but got er
On Tue, 2009-12-22 at 15:10 -0500, Francisco Reyes wrote:
> Only up to 8.4.1 there.
Which os/distro are you looking for? I hope it is not Fedora 11 -
x86_64.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Andrus
> Sent: Tuesday, December 22, 2009 12:03 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] How to add month.year column validation
>
> Database contai
Easy mistake to make
The repo RPM version is 8.4-1 <-- note the hyphen. This is the repo for
all 8.4 versions, including 8.4.2.
Install the proper repo RPM for your platform and then you can just yum
install (or upgrade) PostgreSQL 8.4.2.
To browse the files in the 8.4 repo, try:
http://yu
They also used to be at ftp.postgresql.org:/pub/binary.
There are only rpms up to 8.4.1
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
A. Kretschmer writes:
http://yum.pgsqlrpms.org/reporpms/repoview/letter_p.group.html
Only up to 8.4.1 there.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Dec 22, 2009, at 15:03 , Andrus wrote:
Database contains CHAR(7) type column which must be NOT NULL and
must be in the format
mm.
where:
mm - month number, always two digits in range 01 .. 12
. - separator must be point always.
- must be four digits in range approx. 1980 ..
Hi Andrus,
>
> How to add column validation to table column which forces this ?
You're looking for a constraint - I presume you know what conditions you want
to check for - I've done a similar thing recently ensuring the first character
in a column is a decimal point, or that if one column's
Database contains CHAR(7) type column which must be NOT NULL and must be in
the format
mm.
where:
mm - month number, always two digits in range 01 .. 12
. - separator must be point always.
- must be four digits in range approx. 1980 .. 2110 .
How to add column validation to table
Hi Chris,
Assuming the error condition is resolved, the process should
restart automatically. However, one issue we have found is that there appears
to be an upper limit to how many files `test` can actually check for existence.
We found that it was returning 1 in error and henc
On 22/12/2009, at 18:15, Tom Lane wrote:
> Raimon Fernandez writes:
>> But the portal isn't destroyed after a sync ?
>
> Not directly by a Sync, no.
ok,
>> I'm getting a "Portal 'myPortal' doesn't exist "when sending the next
>> Execute ...
>
> End of transaction would destroy portals ---
Hi, hoping someone can tell me how to get this running again.
I have pitr running and noticed that the slave is far out of date with wal logs.
Upon investigation I see that on the master that /data/pgsql/backups/wal_logs
has over 6000 logs that haven't been moved
to the /var/lib/pgsql/bac
On Tue, Dec 22, 2009 at 10:30, Лев Ласкин wrote:
> Hi.
> We have installed Postgresql 8.3.3. When we see the output of atop-d, we see
> just such a string
>
> db0: ~ # atop 15
> ATOP - db0 2009/12/22 12:14:29 15 seconds elapsed
> DSK | sda | busy 50% | read 72 | write 207 | avio 27 ms |
>
> PID
Hi,
I installed Postgresql 8.4.2 on Centos
5.4 64 bit.
I migrated data from postgres 8.3 to
8.4.2 using PgAdmin 1.10 backup and
restore functions.
We access the data using ODBC.
For some reports, we need to create a
temporal table, fill it and then drop
it.
This kind of programs
Hello,
A customer of mine is running 8.3.8. We are attempting to take a backup,
but whenever we issue pg_start_backup() it always says that we need to first
run pg_stop_backup() - Even when I run the stop backup command right before
trying to start the backup. I have restarted PostgreSQL alto
Raimon Fernandez writes:
> But the portal isn't destroyed after a sync ?
Not directly by a Sync, no.
> I'm getting a "Portal 'myPortal' doesn't exist "when sending the next
> Execute ...
End of transaction would destroy portals --- are you holding a
transaction open for this? It's basically
Tom Lane wrote:
No, but did you do a PQgetResult? See the description of PQgetCopyData.
Oops! Thanks Tom. Even after many re-reads, I missed that final paragraph in
the manual, and have wasted ages on this.
Nathaniel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Nathaniel Trellice writes:
> So, even though the manual states that it's obsolete, do I need to issue a
> call to 'PQendcopy' to tell the server that the copy is complete?
No, but did you do a PQgetResult? See the description of PQgetCopyData.
regards, tom lane
--
Sen
I'm working on a client library, written in C, and am using:
COPY sometable TO STDOUT WITH BINARY
followed by calls to 'PQgetCopyData' to retrieve data from the table as a
postgres binary stream.
All my DB interaction is synchronous.
I've had things working for some time, but recent enhancem
Hello again,
Now that I have working the Extended Query using the Front End Protocol 3.0,
I'm getting better results with simple queries than extended queries.
table comptes:
Simple query:
select * from comptes WHERE codi_empresa = '05' AND nivell=11 and clau_compte
like '05430%' => 0,027
On 19/12/2009, at 16:32, John DeSoi wrote:
>> If I execute with a row limit of 1000, and I know there are more than 1000
>> rows, I get the portalSuspended as described.
>>
>> But, If a issue a new Execute, postgresql says that myPortal doesn't exist
>> anymore.
>>
>> How I can get those 1000
On Tue, Dec 22, 2009 at 10:19 AM, Thomas wrote:
> Does it write data to data files to make buffer "clean"?if it
> does ,but I can not find open files from the result of lsof -p
> PID.
>
writer actually takes care about writing pages down, from shared
memory. It is the central point that accesses
Hi.
We have installed Postgresql 8.3.3. When we see the output of atop-d, we
see just such a string
db0: ~ # atop 15
ATOP - db0 2009/12/22 12:14:29 15 seconds elapsed
DSK | sda | busy 50% | read 72 | write 207 | avio 27 ms |
PID RDDSK WRDSK WRDSK_CANCEL DSK CMD 1 / 2
11296 0K 185.0M 185.0M 97%
Does it write data to data files to make buffer "clean"?if it
does ,but I can not find open files from the result of lsof -p
PID.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tuesday 22 December 2009 5:46:25 am Wappler, Robert wrote:
>
> Assuming we could pass a bulk of rows as a table, the update could be
> performed as follows:
>
> CREATE OR REPLACE FUNCTION update_tpl(measurements SETOF sensor_data)
> RETURNS void VOLATILE AS $$ UPDATE temperature_per_location AS
Phoenix Kiula wrote:
I am not getting all the required rpms for the Postgres version 8.4.2.
What should I be doing?
Using http://yum.pgsqlrpms.org/8.4/ maybe?
It's been a long time since I found either rpbone.net or rpmfind.net to
be very useful, might as well use Google instead to find stu
2009/12/22 Pau Marc Munoz Torres
> Hi every body
>
>
> there is some way to delete or rename an index only if this index exists?
>
> something like
>
> "alter index index rename to pepe if exists"
>
>
for drop - yes:
DROP INDEX IF EXISTS name;
for rename - there is no simple solution. well, a
> -Original Message-
> From: Filip Rembiałkowski [mailto:plk.zu...@gmail.com]
> Sent: Monday, December 21, 2009 6:51 PM
> To: Wappler, Robert
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL]
>
>
> 2009/12/21 Wappler, Robert
>
>
> Hello,
>
> when defining functio
In response to Phoenix Kiula :
> Hi
>
> Not sure what I am doing wrong.
>
> I am not getting all the required rpms for the Postgres version 8.4.2.
http://yum.pgsqlrpms.org/reporpms/repoview/letter_p.group.html
I hope you can find your rpm's there, i'm a debian-user...
Andreas
--
Andreas Kret
Hi
Not sure what I am doing wrong.
I am not getting all the required rpms for the Postgres version 8.4.2.
=
http://rpm.pbone.net/
Your query postgresql-devel-8.4.2 did not match any entry in database.
Your query postgresql-server-8.4.2 did not match any entry in database.
http://ww
2009/12/22 Scott Marlowe
>
> Ahh, right, it's about visibility. Hadn't caught that part.
>
While it appears that the docs and utility are logically consistent, this is
SO counter-intuitive.
I was just scanning the man page from top to bottom, looking for a way to
show all tables...
diff --
Hi every body
there is some way to delete or rename an index only if this index exists?
something like
"alter index index rename to pepe if exists"
thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Auto
Durumdara wrote:
[client_encoding is switched to WIN1250]
> And what happening what DB recognize not win1250 character in SQL?
> Is it converted to "?" or an exception dropped?
> And if the UTF db contains non win1250 character?
> Is it replaced in result with "?" or some exception dropped?
What y
57 matches
Mail list logo
