Adam Mackler wrote:
> I am wanting to define some functions as described in section 35.9 of
> the manual, "C-Language Functions." I am compiling pre-existing files
> of c-code from another project into object files, and then linking
> those object files into a shared library along with my own func
Oliver Dizon wrote:
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
>
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
>
> --from a certain script where table_id is not yet existin
Tim Smith wrote:
> Is there a more efficient way to pattern match integer columns other
> than something like :
>
> where cast(mynumber as text) ~ '.*123.*'
>
>
> I also seem to recall you can't create indexes on casts either ?
I don't think you can do this without converting the column to a st
sri harsha wrote:
>>>Is there any way to stop concurrent inserts to happen on a single table
>>> ??
>> If you really want that, it is easy with table locks.
> Actually i am using a FDW , in which the data is written into a single
> file. So when i do
> concurrent inserts , the data is w
sri harsha wrote:
>Is there any way to stop concurrent inserts to happen on a single table ??
>
> Query 1 : INSERT INTO TABLE_A SELECT * FROM TABLE1;
> Query 2 : INSERT INTO TABLE_A SELECT * FROM TABLE2;
> Query 3 : SELECT * FROM TABLE_A;
>
> Assume i have the above queries. Query 1 and Query
Thomas Kellerer wrote:
> Albe Laurenz schrieb am 17.12.2014 um 11:07:
>> and the performance will be worse than reading files from the file system.
>
> There is a Microsoft research [1] (from 2006) which tested this "myth" using
> SQL Server.
> It showed that
VENKTESH GUTTEDAR wrote:
> I am using PostGreSQL 9.3.5 and DJango1.7.5 and python 3.3.
>
> I am working on a application where i will get video files from mobile app,
> and i have to store in the server,
> so my question is how do i store video's or video files in DB, or do i need
> to store onl
AJ Welch wrote:
> http://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/
>
> I suspected some of the claims in the post may not have been accurate. This
> one in particular:
>
> "Without lateral joins, we would need to resort to PL/pgSQL to do this
> analysis. Or, if our data
Thomas Kellerer wrote:
> I just encountered something like this in an execution plan:
>
> -> Hash (cost=19865.48..19865.48 rows=489 width=12) (never executed)
> Output: ly.total_count, ly.customer_id
> -> Subquery Scan on ly (cost=19864.50..19865.48 rows=489 width=12)
> (never exe
sri harsha wrote:
> Is it possible to implement TRUNCATE and CREATE TABLE LIKE for a foreign
> table. Is there anyway i
> can write a function to implement those queries in my FDW ??
This is currently not possible, it would need an extension to the FDW API.
If you can come up with a good design,
David G Johnston wrote:
> Albe Laurenz *EXTERN* wrote
>> Paul GOERGLER wrote:
>>> I have a lot of tickets, i need to take a batch of tickets and process
>>> them.
>>> So the process is :
>>> SELECT ONLY 100 tickets
>>> PROCESS ticket
>>&g
Olivier MATROT wrote:
> Serialization conflict detection is done in
> src/backend/storage/lmgr/predicate.c, where transactions
> that are doomed to fail are marked as such with the SXACT_FLAG_DOOMED flag.
>
> I simply added elog(NOTIFY,...) calls with the DEBUG1 level, each time the
> flag is se
Paul GOERGLER wrote:
> I have a lot of tickets, i need to take a batch of tickets and process them.
> So the process is :
> SELECT ONLY 100 tickets
> PROCESS ticket
> MARK THEM AS « done »
>
> I’m selecting the tickets with :
>
> WITH t0 AS (
> SELECT t.id,
> RANDOM() AS rank,
> EXTRACT(EPOCH
Anil Menon wrote:
> I would like to ask from your experience which would be the best "generic"
> method for checking if row
> sets of a certain condition exists in a PLPGSQL function.
>
> I know of 4 methods so far (please feel free to add if I missed out any
> others)
[...]
Are you aware that
Marcos Cano wrote:
[missing data after dump/restore of DB with PostGIS]
> i found this in the file...
>
> ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or
> directory
Could it be that PostGIS was not installed as an extension in the old database,
so that the dump contains th
Jonathan Vanasco wrote:
> On Nov 17, 2014, at 12:55 PM, Robert DiFalco wrote:
>> SELECT * FROM MyTable WHERE upper(FullName) LIKE upper('%John%');
>>
>> That said, which would be the best extension module to use? A "gist" index
>> on the uppercased column?
>> Or something else? Thanks!
>
> Pe
Brilliantov Kirill Vladimirovich wrote:
>> You should post the table definition and the whole trigger; the error
>> message seems to refer to things you omitted in your quote.
>
> Table with statistic:
> CREATE TABLE trassa.cpu_load_stat
> (
>id serial NOT NULL,
>device integer NOT NULL,
>
Brilliantov Kirill Vladimirovich wrote:
> I use Postgre-9.3.5 on windows7 x64.
> I use simple trigger for store some statistic data, it code:
> SELECT field IN variable FROM table WHERE ...;
> IF FOUND THEN
>UPDATE table SET field = ...;
> ELSE
>INSERT INTO table (field) VALUES(value);
> EN
dineshkaarthick wrote:
> I would like to know how is the "Shared Disk Failover" replication achieved
> if it is not possible to share the data directory ? I am referring to the
> 1st solution in the mentioned link,
> http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html
Yo
avpro avpro wrote:
> in the pgsql documentation
> (http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html)
>
>
> i haven't seen anything referring to: how is affected the data inserted in
> the new table by a trigger
> Before Insert compared with a trigger After Insert? and anything re
Brilliantov Kirill Vladimirovich wrote:
> I install postgre from postgresql-9.3.5-3-windows-x64.exe file and try
> use libpq.lib from it.
> My system Windows7 ServicePack1 and I use VisualStudioExpress 12 for
> write code.
> I add path to \include and
> \lib in project and include libpq-fe.h file.
Jerome Wagner wrote:
[wants to access an application server farm with FDW]
> Clearly, I am trying to see how I could twist the fdw wrappers into a sort of
> manhole inside the
> application, without resorting to a classic event based mechanism.
That's too metaphorical for me to understand.
> I c
Jerome Wagner wrote:
> I am considering (postgres 9.3+) the idea of opening a R/W access into a
> clustered application by
> creating one fdw server from a central database to each server a cluster.
>
> That would imply opening a port on each server inside the application,
> listening for incomi
Matthew Chambers wrote:
> Would something like this work best, or is it better to use pgdump?
>
> CREATE DATABASE newDatabase TEMPLATE oldDatabase ENCODING 'UTF8'
>
> Does using a template do a file system copy or just SQL copy everything over?
Using the old database as template will not change
Cedric Berger wrote:
>>> 1) What is the easiest way to get that directly in C?
>>
>> The usual locution is "get_database_name(MyDatabaseId)".
>
> Ok, but then how do I find "MyDatabaseId" in, say,
> a BeginForeignScan() or GetForeignRelSize() FDW callback?
It is a global, all you should have to d
Anthony Burden wrote:
> validate some software with you to
> ensure that all our installed PostgreSQL software meets SHA-256 compliance.
> There is basically two things we are looking for:
>
> 1) Identify all COTS software purchased as part of scheduled and budgeted
> technology refreshes and upgr
Evan Martin wrote:
> I'm using PostgreSQL 9.2.8 via Npgsql 2.2.0. When a query times out it
> returns error 57014 with the message "canceling statement due to
> statement timeout". I use the message to detect the timeout and re-try
> in some cases. It seems a bit wrong to rely on the message, thoug
Philipp Kraus wrote:
> I need around 150 copies of a database (for an exam). I have got a
> database with tables and data and for my exam I would copy this
> database in his way:
>
> database_source
>
> database1
> database2
> ….
> database150
>
> Is there a buildin way to clone the "database_so
Vinayak wrote:
> We are converting the Oracle's CREATE SYNONYM statement into PostgreSQL.
> I think to replace the SYNONYM we use search_path in PostgreSQL and the same
> thing is explained in the below post also.
> http://postgresql.1045698.n5.nabble.com/Synonyms-in-PostgreSQL-9-2-4-td5757986.html
Arnaud Lesauvage wrote:
> I just came accross this trying to upgrade my server from 8.4.8 to 9.3.4 :
>
> SELECT substring('²' FROM E'\\d');
>
> 8.4 : NULL
> 9.3 : "²"
>
> Am I correct to expect NULL in this case ?
I get a different result on Linux:
test=> SHOW server_encoding;
server_encoding
Vinayak wrote:
> We have converted Oracle SYSDATE to PostgreSQL statement_timestamp() but
> there is a difference in timezone.
> SYSDATE returns the time on the server where the database instance is
> running(returns operating system time) so the time depends on the OS
> timezone setting.
> while t
Sameer Thakur wrote:
>> My experience is that you cannot set breakpoints before the library
>> is loaded, so you first have to call a function in the library, then
>> you interrupt and set the breakpoint.
> I tried to do the following
> 1. Execute Postgres (now auto_explain is loaded)
> 2. Start a
Sameer Thakur wrote:
> In the process of implementing my own version of sysdate, i was trying
> to use the fmgr_hook.
[...]
> To debug i have a breakpoint inside custom_fmgr_hook.
>
> Debugging:
> 1. Start postgres
> 2. Start psql connecting to postgres
> 3. Attach gdb to process spawned off by
Jose Moreira wrote:
> I guess this is easy a question for the gurus, but afraid I cannot get te
> answer!
>
> I have this table:
>
> aif_test=# \d sbox;
> Table "public.sbox"
> Column | Type | Modifiers
> ++---
> id |
dushy wrote:
> Iam running a postgresql 9.0.13 master/slave instance in a write heavy
> workload.
>
> The hardware is a Dell 720, E5530 - 8 core, 128GB RAM. The database (around
> 250g with indexes/bloat etc) is sitting on flashcache device with 2 fusion-
> io PCIe MLC SSDs as frontend and a MD320
Sylvia Preuß wrote:
> I’d like to create a database with ENCODING LATIN1 .
>
> CREATE DATABASE z_latin1
> WITH OWNER = admin
>ENCODING = 'LATIN1'
>TABLESPACE = pg_default
>LC_COLLATE = 'German_Germany.1252'
>LC_CTYPE = 'German_Germany.1252'
>CONNECTION LIM
Andrus wrote:
>> Use "bpchar" instead of "text" in the definition of function and operator.
>> Otherwise col1 gets cast to "text" and loses its trailing spaces.
>
> Thank you very much.
> It worked.
> Which notation to use for this ?
>
> Is it reasonable use "+" as such operator for strings or sh
Andrus wrote:
> How to create string concatenation operator which preserves trailing spaces
> on CHAR(n) type columns ?
>
> I tried code below, but it returns AB (without spaces).
> How to force it to return A B (keep space after A) ?
>
> Andrus.
>
> CREATE OR REPLACE FUNCTION public.stringconca
Eelke Klein wrote:
> I'm experimenting with using foreign data wrappers to get data from one
> database to another. Most
> things work perfectly but I am encountering two issues with triggers on the
> foreign tables.
>
> The first one is when a query triggers a trigger on the foreign table the
David G Johnston wrote:
>> Also, I think that your method is vulnerable to race conditions:
>> If somebody else increments the sequence between the INSERT and
>> "SELECT lastval()" you'd get a wrong value.
>
> Uh, no. It returns that last value issued in the same session - which is
> race-proof.
rob stone wrote:
>> I have a question on the right/correct practice on using the serial
>> col's sequence for insert.
>>
>> Best way of explanation is by an example:
>>
>> create table id01 (col1 serial, col2 varchar(10));
>>
>> insert into id01(col2) values ( 'data'||
>> currval('id01_col1_seq')::
Madhurima Das wrote:
> I am writing a C program to access a PostgreSQL database, where
> I add a column if it doesn't exists in the table
> or, update the column, if the column already exits.
> Please suggest how to work with the conditional statements.
> N.B. I wrote the following:
>
> res = PQe
John R Pierce wrote:
> On 7/4/2014 2:12 AM, sunpeng wrote:
>> Thank you, friend, I use --hex-blob :
>> mysqldump -v -nt --complete-insert=TRUE --compatible=postgresql
>> --default-character-set=utf8 --skip-add-locks --compact
>> --no-create-info --skip-quote-names --hex-blob -uroot -p test
>> vide
sunpeng wrote:
>>> load data to postgresql in cmd(encoding is GBK) is WIN8:
>>>
>>> psql -h localhost -d test -U postgres < dbdata.sql
>>>
>>> I got the error:
>>> ERROR: invalid byte sequence for encoding "UTF8": 0xff
>> If the encoding is GBK then you will get errors (or incorrect
>> charact
Arup Rakshit wrote:
> yelloday-staging::YELLOW=> select id, dob from users;
> id | dob
> +-
> 13 |
> 9 | 1967-02-13 14:00:00
> 10 |
> 11 |
> 8 | 1977-06-05 14:00:00
> 15 |
> 21 |
> 14 | 2014-05-25 14:00:00
> 37 |
> 22 |
> 26 | 2014-05-06 14:00:00
> 32
Yvonne Zannoun wrote:
> I have this question regarding delete triggers and how it affects data
> integrity.
> So here goes: I have this trigger which deletes everything before I insert
> new rows.
>
> CREATE OR REPLACE FUNCTION delete_records()
> RETURNS TRIGGER AS $$
> BEGIN
> delete from "
Dmitry Samonenko wrote:
> I have an application which uses libpq for interaction with remote PostgreSQL
> 9.2.4 server. Clients
> and Server nodes are running Linux and connection is established using TCPv4.
> The client application
> has some small fault-tolerance features, which are activated w
Victor Sterpu wrote:
> When I run the query from down I receive an error.
> How can I write this query to receive the day ot the week.
> SELECT EXTRACT(DOW FROM timestamp TO_TIMESTAMP('14-10-2011', 'DD-MM-'));
Maybe you mean
SELECT EXTRACT(DOW FROM TO_TIMESTAMP('14-10-2011', 'DD-MM-'));
Sameer Kumar wrote:
> I guess I will be exploring more on oracle foreign data wrapper.
>
> Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would
> it handle failovers.
I have not tried it, but it should work as follows:
- You'll have to use a connect string that is correct
Sameer Kumar wrote:
> I need to setup a replication process for continuously replicating changes
> happening in an Oracle
> Database to a PostgreSQL database.
>
>
> My Oracle Database is version 11.2 and setup as a cluster with RAC
> My Postgres database version is 9.2
>
> Oracle Database is ru
Suya Huang wrote:
> I’ve encountered a weird problem in PostgreSQL :
>
> postgres=> create user test password ‘test’;
>
> postgres=> grant select on pg_catalog.pg_database_size to test;
This statement produces an error:
ERROR: relation "pg_catalog.pg_database_size" does not exist
> postgres=> g
Hello World wrote:
> Denial of service is indeed a problem. Is there a way to limit the execution
> time of a request?
Yes, setting statement_timeout.
But if a client can exectue arbitrary statements, that could also
be statements like:
SET statement_timeout=0;
SET work_mem=1024GB;
> I'm using
Hello World wrote:
> Given this are there any security other issues about letting client
> applications execute arbitrary SQL
> commands on the backend database?
There shouldn't be any security problems, just be careful that you don't give
the
user more permissions than you want to.
But a user
Dev Kumkar wrote:
> Faced following issue when trying to start database using pg_ctl:
>
> FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission
> denied
>
> Accidentally someone cleaned up /tmp and recreated it but without any write
> permissions to non-root
> user, if the no
basti wrote:
> is it possible to have WAL Replication and Point-in-Time Recovery like
> follows:
>
> DB-Master -- (WAL to Slave) --> DB-Slave
> |
> |---> (PITR to an other Server)
>
> Thanks for any help!
Sure. You can use something like the UNIX command "tee" in "archive_command"
t
> Torsten Förtsch wrote:
>>> I got this plan:
>>>
>>> Limit (cost=0.00..1.12 rows=1 width=0)
>>>-> Seq Scan on fmb (cost=0.00..6964734.35 rows=6237993 width=0)
>>> Filter: ...
>>>
>>> The table has ~80,000,000 rows. So, the filter, according to the plan,
>>> filters out >90% of the
Nicklas Avén wrote:
> I have also found in an email from 2011
> http://www.postgresql.org/message-id/4e699de6.8010...@gmail.com
>
> that when force_not_null was implemented in file_fdw the patch also included
> "some cosmetic changes
> such as removing useless blank lines."
That is refering to b
Dev Kumkar wrote:
>> Unless somebody changes the setting to ssl=on, there should be no problem.
> Thanks also please help to understand - does changing this postgresql.conf
> setting enough to be
> vulnerable here?
Just changing the setting will only cause your database server to error
out on re
Glenn Pierce wrote:
> I have a table like
>
> CREATE TABLE sensor_values
> (
> ts timestamp with time zone NOT NULL,
> value double precision NOT NULL DEFAULT 'NaN'::real,
> )
>
> It was intended that ts timestamps would be the time we wanted to store in
> UTC.
> Clients would adjus
Dev Kumkar wrote:
> Can you please let us know about the impact in case binaries are being
> shipped and SSL is off?
Unless somebody changes the setting to ssl=on, there should be no problem.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
Raymond O'Donnell wrote:
>>> Interestingly, I get different results (on both 9.1.4 and 9.3.0) on
>>> Windows:
>> I'm not particularly surprised that Windows is not being IEEE compliant, and
>> instead chooses the more common round-away-from-zero behavior, here though I
>> am unsure where the depen
> Anupama Ramaswamy wrote:
>>> I would like to setup a 2 servers with streaming replication, one master
>>> and another hot standby.
>>> I want to use the standby for read-only queries. So I want the replication
>>> lag to be as small as
>>> possible.
>>> So I choose streaming replication over WA
Jack.O'Sullivan wrote:
> I am working for a client who is interested in migrating from Oracle to
> Postgres. Their database is
> currently ~20TB in size, and is growing. The biggest table in this database
> is effectively a BLOB
> store and currently has around 1 billion rows.
>
> From reading a
Anupama Ramaswamy wrote:
> I would like to setup a 2 servers with streaming replication, one master and
> another hot standby.
> I want to use the standby for read-only queries. So I want the replication
> lag to be as small as
> possible.
> So I choose streaming replication over WAL shipping.
>
John R Pierce wrote:
> On 4/10/2014 1:01 AM, Albe Laurenz wrote:
>> If you are in a totally trusted environment, why would you use SSL?
> Belt, and suspenders.
I guess what I wanted to say was:
If you are concerned enough to use SSL, you should be concerned enough
to change your
Steve Crawford wrote:
> On 04/09/2014 08:54 AM, "Gabriel E. Sánchez Martínez" wrote:
>> Hi all,
>>
>> Our server is running Ubuntu Server 13.10 (we will soon upgrade to
>> 14.04) and PostgreSQL 9.1. We use certificates for all client
>> authentication on remote connections. The server certificat
Thomas Kellerer wrote:
> I usually create new databases with an explicit owner which is the
> "application user" that is used by
> the application to connect to the database.
>
> I recently noticed when I do the following:
>
> postgres=# create user arthur identified by 'secret';
> postgres=# cr
Rebecca Clarke wrote:
> On a side
> not, we're not doing a vacuumdb, but individual vacuum analyze statements on
> each table. Not sure if
> that makes any difference.
You vacuum the catalog tables as well, right?
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgr
howardn...@selestial.com wrote:
>> http://www.postgresql.org/docs/current/static/collation.html#AEN33298
>> The ordering depends on the collation. Which collations are available
>> and how they order depends on your operating system. What is your OS
>> and what do you get for SHOW lc_collate; Yours
howardn...@selestial.com wrote:
> just as I thought I had postgres mastered :) the ordering of strings is
> causing me some confusion.
>
> Can someone explain how the database orders strings in the ORDER BY command.
>
> My example:
>
> My database is encoding is UTF-8, and default language is e
Rebecca Clarke wrote:
> I'm a bit stumped. At present I'm finding that queries to my database, that
> normally execute promptly,
> are taking a long time when they are executed first thing in the morning
> (after the database has been
> inactive for several hours). After the first execution, ever
Kohler Manuel wrote:
> I have a question regarding the use of indices when querying foreign data
> tables (using postgres_fdw
> of 9.3 to another postgres DB).
> Everything works fine beside the fact that the indices which are defined in
> the foreign DB are not
> used at all when I do query it t
Scot Kreienkamp wrote:
> I have a table like so:
>
> Receiptlimitid: BIGINT (Primary Key)
> Profitcenterid: BIGINT
> Receiptnumber: INTEGER
>
> All are set to Not Null also.
>
>
> My question is, if I have an insert that goes idle in transaction for a while
> before it commits, will
> it stop
loc wrote:
> I'm currently using an Informix Innovator-C database with Aubit4GL and I
> would like to migrate to
> PostgreSQL, it looks like the transition will not be too difficult, however
> there is one feature that
> I would like added to PostgreSQL. Where is the best place to request a
> f
Emanuel Araújo wrote:
> I have a problem wiht Oracle FDW 0.9.10 in PostgreSQL 9.3
>
> I am using pg 9.3.4
>
> Oracle FDW 0.9.10
>
> Fedora 20
>
> Client Oracle Release 11.2.0.3.0
>
>
> Return Error:
>
> ERROR: cache lookup failed for type 0
This is a known bug, the fix is already committed
Oscar Calderon wrote:
> Everybody have a nice day. Well, finally the place where i currently work
> paid me a chance to take the
> Associate Certification exam and i'm reviewing some topics, specifically the
> topics that the exam
> covers (some of them are easy to me like psql, which i use almos
Vito wrote:
> I'm recently doing some research with Apache ODE engine. I use Postgresql as
> its external database,
> openjpa as its ORM solution and bitronix as its transaction manager. The ODE
> workflow engine starts
> without any problem. But when I deploy process definition files into the
>
basti wrote:
>>> Since a few days we had problems with the Linux OOM-Killer.
>>> Some simple query that normally take around 6-7 minutes now takes 5 hours.
>>> We did not change any configuration values the last days.
>>>
>>> First of all I have set
>>>
>>> vm.overcommit_memory=2
>>> vm.overcommit_
Peter Mogensen wrote:
> I have an application where I would really like to be able to look at en
> SQL query and answer the question:
>
> "Is this query capable of returning more than 1 row?"
> Can I conclude that when plan_rows is 1 then there will never be more
> than 1 row returned by the quer
nill wrote:
> Given a view, I need to extract tables, the join columns (ON) . I need to do
> this analysis because of the view (agreements with the join condition and
> where) I can say that there is a foreign key
Do I understand right that you want to find out the tables involved in
a view defini
matshyeq wrote:
> Postgresql is there for a good while perceived as one of the best (or just
> simply the best!?)
> available open source DB solution, so I'm really surprised this functionality
> is not yet supported...
You can retrieve the full result set,
you can retrieve it row by row,
you ca
Daniel Verite wrote:
> matshyeq wrote:
[ runs out of memory on the client because all results from a large query are
retrieved at once ]
>> "Unfortunately, this is a limitation in the underlying driver (libpq) rather
>> than DBD::Pg itself. There have been talks over the years of supporting
>> t
Tom Lane wrote:
> Albe Laurenz writes:
>> Is there anything that "varchar_pattern_ops" is needed for that
>> "text_pattern_ops" cannot provide?
>
> Lack of surprise? If you're creating a pattern index on a varchar column,
> you'd likely
I understand the difference between "*_ops" and "*_pattern_ops".
But look at the following:
CREATE TABLE test (v varchar(30));
CREATE INDEX test_v_ind ON test (v varchar_pattern_ops);
CREATE INDEX test_t_ind ON test (v text_pattern_ops);
SET enable_seqscan = off;
EXPLAIN VERBOSE SELECT * FROM t
Jürgen Fuchsberger wrote:
> One very important thing I just noted when shutting down and restarting
> my standby server:
>
> My standby server *always needs the last WAL-file* from the archive
> directory, even when the shut down was "smart". Without this the
> consistent recovery state will not b
Rob Goethals wrote:
> OK, clear. I hereby send this reply also to the list.
Cool.
>> Interesting.
>> How did you get PostgreSQL into this state? Did you set fsync=off or
>> similar?
>> Which storage did you put pg_xlog on?
> 2014-02-15 00:49:04 CET LOG: WAL writer process (PID 1127) was term
Rob Goethals wrote:
> This is my first post to this list, so I hope I am posting it to the correct
> lists. But I am really
> stuck and getting pretty desperate at the moment.
You should not post to more than one list.
> This weekend my database crashed while importing some Openstreetmapdata and
James Sewell wrote:
> If it is the the only way that I could achieve what I wanted would be to set
> wal_keep_segments high enough then they will all be archived on promotion?
Even if you set wal_keep_segments high I don't think that the replayed
WAL will be archived.
> I'm still not sure why the
[CC'ed -hackers]
Tsubasa Sakamoto wrote:
>> Not sure that it makes a difference but the docs say psql looks at
>> LC_CTYPE not LANG for Unix systems. You did not say what OS you are
>> working on though from the examples I am guessing some form of Unix.
> The LC_CTYPE environment variable was set
James Sewell wrote:
> My understanding is that WAL archiving can not be enabled on the slave in a
> streaming replication
> pair.
It can be enabled. Did you try it?
> If this is correct, is there a reason behind it? I can see logs showing up in
> pg_xlog, so could they
> not be archived?
Thes
mephysto wrote:
> Is it possible that it is read-uncommitted transaction isolation level?
No; there is no such thing in PostgreSQL.
The lowest isolation level is READ COMMITTED.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
Chris Curvey wrote:
> Is there a trove of Windows installers for FDWs? I'd like to try a
> proof-of-concept with the
> ODBC_FDW.
>
> In the meantime, I'll try to go figure out how to go about building from
> source on windows, but if I
> can avoid that learning curve for my POC, that would be g
mephysto wrote:
> Hi Albe, this is code of my stored function:
> CREATE OR REPLACE FUNCTION :FUNCTION_SCHEMA.get_deck_types
[...]
> BEGIN
[...]
> CREATE LOCAL TEMPORARY TABLE deck_types
> ON COMMIT DROP
> AS
> SELECT
> stored_fu
mephysto wrote:
> in my database I'm using several stored_functions that take advantage of
> temporary table. The application that is connected to Postgres is a Java Web
> Application in a Glassfish Application Server: it is connected by a JDBC
> Connection Pool provided by Glassfish with this sett
Thomas Kellerer wrote:
>>> I asked this a while back already:
>>>
>>>select to_date('2013-02-31', '-mm-dd');
>>>
>>> will not generate an error (unlike e.g. Oracle)
>>
>> This is by design.
>
> When I previously asked this question the answer as "this is based on
> Oracle's to_date()":
>
Thomas Kellerer wrote:
> I asked this a while back already:
>
>select to_date('2013-02-31', '-mm-dd');
>
> will not generate an error (unlike e.g. Oracle)
This is by design.
> However in the release notes of 9.2.3[1] it is mentioned that
>
> - Reject out-of-range dates in to_date() (
Sergey Konoplev wrote:
> On Mon, Dec 30, 2013 at 12:27 AM, Albe Laurenz
> wrote:
>> Joe Van Dyk wrote:
>>> If I run "COPY (select * from complicate_view) to stdout" on the standby,
>>> I've noticed that sometimes
>>> halts replication updat
Joe Van Dyk wrote:
> If I run "COPY (select * from complicate_view) to stdout" on the standby,
> I've noticed that sometimes
> halts replication updates to the slave.
>
> For example, that's happening right now and "now() -
> pg_last_xact_replay_timestamp()" is 22 minutes.
> There's many transac
ERR ORR wrote:
> This is just to say that I upgraded from V9.2.6 to V9.3.2.
>
> Same HW, same data, an astonishing performance increase.
> Postgres is flying
It lies in the nature of a support mailing list that most of the feedback
you get is like "we upgraded, and this and that is much slower no
Ralf Schuchardt wrote:
> Am 19.Dez. 2013 um 09:41 schrieb Andreas Kretschmer :
>> don't ask why, but a customer created tables with foreign key constraints but
>> with inconsistent data.
>>
>> Because of this he disabled all triggers (alter table foo disable trigger
>> all).
>> So far, so bad ...
201 - 300 of 1244 matches
Mail list logo
