Re: [GENERAL] BDR with Postgres

vriendelijke groet, Serge Fonville http://www.sergefonville.nl 2015-03-17 10:01 GMT+01:00 Deole, Pushkar (Pushkar) : > Hi, > > > > I just tried a POC with PostgreSQL’s streaming replication for the use > case of my product. Since streaming replication is master-slave, when > fail

Re: [GENERAL] SQL Server access from PostgreSQL

If you use odbc you should be able to use https://msdn.microsoft.com/en-us/library/hh568451%28v=sql.110%29.aspx Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl 2015-06-07 1:08 GMT+02:00 Geoff Montee : > On Mon, May 18, 2015 at 11:24 AM, Geoff Montee >

Re: [GENERAL] Help needed with postgres stats and math

normSum FROM NormCTE ORDER BY normSum DESC HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl 2014-08-03 13:20 GMT+02:00 Tim Smith : > Hi, > > I'm on Postgres 9.3.5, however I think my knowledge of Postgres is not > deep enough to help me wi

Re: [GENERAL] Help needed with postgres stats and math

Or... Do you mean to use windowing functions? http://www.postgresql.org/docs/9.3/static/tutorial-window.html Or both of course... Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl 2014-08-04 19:43 GMT+02:00 Serge Fonville : > Hi, > > Perhaps a CTE w

Re: [GENERAL] pgadmin connection via tunnel and ubuntu user instead of postgres

connecting HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table 2013/1/13 Adrian Klaver >

Re: [GENERAL] Combining validation into main query

If you use EXISTS in the WHERE clause, you should come closer to what you want realised. For further help it would make it easier if you shared the whole queries and perhaps a more detailed description of the goal you are trying to accomplish. HTH Kind regards/met vriendelijke groet, Serge

Re: [GENERAL] INSERT... WHERE

Hi, Based on my understanding of the problem, would this be possible to solve with a MERGE statement? HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https://connect.microsoft.com

Re: [GENERAL] INSERT... WHERE

Hmm, nvm :-( PostgreSQL does not yet support MERGE... Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of

Re: [GENERAL] PostgreSQL and VIEWS

greSQL performance to some other implementation, could you share which one that is? Have you defined things like Foreign Key constraints, Indexes, Statistics? Also could you share some queries and their plans? HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Con

Re: [GENERAL] Foreign Key violated

Hi, I'm not sure if I understand your issue, but could you output SELECT COUNT(*) FROM rmas WHERE id = 1008122437 AND status = 'r'; HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITIO

Re: [GENERAL] coalesce function

Hi, http://www.postgresql.org/docs/9.1/static/functions-conditional.html describes NULLIF, when combined with COALESCE it should answer your request. HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in

[GENERAL] Group by on %like%

What is the output you are trying to achieve? > However, the same phone number might have a prefix on occasion, example : > > name | phone_number > -- > james | 123456 > james | 00441234556 > james | 555666 > sarah | 567890 > sarah | 567890 > > as you can see, the first 2 James

Re: [GENERAL] Vacation reply

with the correct information Regards, Serge Fonville On Fri, Jul 3, 2009 at 11:52 AM, wrote: > Dear Friends: > >    We are a large wholesaler who mainly sell electrical products > such as laptop,TV,digital camera, mobile, Digital Video, Mp4, GPS, and so > on. And our

Re: [GENERAL] initdb failure on Windows XP

etting my PGDATA to > C:\postgres\data which is an empty directory and i am running it (initdb) > as administrator user. Could you post the exact steps, settings and output? That makes it a lot easier to determine the exact issue. Also, have you checked the event log? Regards, Serge Fon

Re: [GENERAL] Getting database data from the PostgreSQL file system

data of some sort without needing the information to interpret that data? After googling for restore corrupted postgresql, I found http://cobaltfaqs.com/index.php/Rebuilding_corrupt_PostgreSQL_database, which may be relevant. Perhaps you need to specify the exact error you get... HTH. Regards, Serge Fonville

Re: [GENERAL] What kind of JOIN, if any?

matching from another use outer join HTH Regards, Serge Fonville On Thu, Sep 17, 2009 at 4:29 PM, Paul M Foster wrote: > Folks: > > I can't find a way to do this purely with SQL. Any help would be > appreciated. > > Table 1: urls > > id | url > -

Re: [GENERAL] PK referenced function

to solve. HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! Please don't get rid of the MCM and MCA programs<https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table> 2013/

Re: [GENERAL] PostgreSQL vs Mongo

into for example Apache Cassandra. HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl 2013/10/17 Bill Moran > > If they pull out the "Mongo is faster than PostgreSQL" card, I'll state > that > I investigated this for my current empl

Re: [GENERAL] Need help with upsert

Hi, > ERROR: column reference "firewall" is ambiguous > LINE 3: ... a WHERE NOT EXISTS (SELECT * FROM upsert b WHERE b.firewall... set firewal = misses a table HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl 2013/12/4 Eric Lamer &g

Re: [GENERAL] Oracle to PostgreSQL replication

on-server> ? Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl 2014-05-07 11:44 GMT+02:00 Geoff Montee : > > On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar wrote: > >> Hi, >> >> >> I need to setup a replication process for continuously repl

Re: [GENERAL] CTE materializing sets?

This indeed is a very interesting question. At http://wiki.postgresql.org/wiki/CTEReadme it seems to suggest that a CTE is just rewritten and the resulting query is executed. Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add

Re: [GENERAL] When does CLUSTER occur?

MSSQL uses an index to maintain the cluster. If a record fits between it places it there, if it doesn't, it considers either moving data or adding it physically out of order (while maintaining the index) Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Con

Re: [GENERAL] When does CLUSTER occur?

The data files contain only one active version of every record. Different versions of that same record are maintained in a version store. Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https

Re: [GENERAL] do I need a table function to do this?

Hi, Assuming the columns in t2 are fixed, you should be able fairly easy solve this using a cursor. HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https://connect.microsoft.com/SQLServer

Re: [GENERAL] archive_command

I tried the following > command, but it did not work: > > archive_command = 'if not exist C:\\pgsql\\backup_in_progress || copy > %p C:\\pgsqlarchive\\%f' > > The error is: > > || was unexpected at this time. windows does not support OR in batch files. if you remov

[GENERAL] Socket error instead of Access denied

Recently I started to move from MySQL to PostgreSQL.When I had it set up on windows, I enabled ssl and everything worked like a charm. My pg_hba.conf looks like this: hostsslallpostgres 127.0.0.1/32 md5 hostssl ticketsystem ticketsystem127.0.0.1/32md5 hostsslfaq faq 127.0.0.1/32 md5 hostssl allpo

[GENERAL] Fwd: Socket error instead of Access denied

ction kept Is this due to the SSL connection, or is it related to some other error And is it 'fixable' I already searched the mailing list and google, but to no avail. Thanks in advance Serge Fonville

[GENERAL] Socket error instead of Access denied

One thing I forgot. The errors occur when I use psql.exe with the -U paramter -- Forwarded message -- From: Serge Fonville <[EMAIL PROTECTED]> Date: Fri, Oct 10, 2008 at 3:00 PM Subject: Fwd: Socket error instead of Access denied To: pgsql-general Sorry about that, submit

Re: [GENERAL] Annoying Reply-To

On Fri, Oct 17, 2008 at 9:26 PM, Serge Fonville <[EMAIL PROTECTED]>wrote: > Altough I am not sure what the real issue is,I do know that on (for > example) the tomcat mailing list, when I choose reply (in gmail) the to: > field contains the address of the mailing list. > Based on

Re: [GENERAL] nearest neighbor search from xyz coordinates

distance Regards, Serge Fonville On Mon, Oct 27, 2008 at 11:50 AM, Andreas Jochem <[EMAIL PROTECTED]> wrote: > Hello, > > I have a table containing x y z coordinates. But I have no geometry column? > Is it possible to find the k nearest neighbors of any point. Is there > something

Re: [GENERAL] Can't restart Postgres

Hi, Did you check permissions? Do the pid files exist? What variables are set? Regards, Serge Fonville On Wed, Oct 29, 2008 at 4:43 PM, Thom Brown <[EMAIL PROTECTED]> wrote: > Hi, > > I've got a development virtual server which matches live exactly > except for th

[GENERAL] Specific user does not require password for postgres

is is only a local development installation, I would really like to understand why this happens Thanks in advance, Serge Fonville

Re: [GENERAL] Error in starting Postgresql...

Have you checked the logsWhat have you configured What os are you using What version of postgresql Have you run netstat to check for port 5432 Regards, Serge Fonville On Wed, Nov 5, 2008 at 4:11 PM, Joshua Tolley <[EMAIL PROTECTED]> wrote: > On Wed, Nov 05, 2008 at 08:34:55PM +0530,

Re: [GENERAL] [JDBC] Re : [pgadmin-support] trouble in installing postgreSQL 8.3

To resolve the issue, a little bit more information would be very useful.What OS are you using What resource have you used to install the software (tutorial,howto,reference, guide,etc) What is the exact error you get and what program gives that error Regards, Serge Fonville On Fri, Nov 14, 2008

Re: [GENERAL] [JDBC] Re : [pgadmin-support] trouble in installing postgreSQL 8.3

ot;localhost") > Try "createdb --help" for more information. > > > > > > > Message du 14/11/08 14:55 > > De : "Serge Fonville" > > A : pgsql-general@postgresql.org, [EMAIL PROTECTED] > > Copie à : > > Objet : Re: [JDBC] Re : [pgadmin-support] tr

[GENERAL] PostgreSQL Windows x64 Build

am currently running Windows Vista x64 and have mingw-w64 and Visual Studio 2008 installed Thanks a lot in advance. Serge Fonville

Re: [GENERAL] High Availability for PostgreSQL on Windows 2003.

e you previously configured a similar application (SQL Server,Exchange,ISA,etc) Is moving to another OS an option How long should implementation take Regards, Serge Fonville On Tue, Nov 18, 2008 at 5:09 PM, Pietro Tedesco < [EMAIL PROTECTED]> wrote: > We have an instance of PostgreSQL o

Re: [GENERAL] High Availability for PostgreSQL on Windows 2003.

e you previously configured a similar application (SQL Server,Exchange,ISA,etc) Is moving to another OS an option How long should implementation take Regards, Serge Fonville

Re: [GENERAL] [NOOB] try tu put a number with pqexecprepare

: 'netinet/in.h': No such file or directory To resolve the lack of 'netinet/in.h' on Windows, take a look at uwin, gnuwin and libgw32c Hope this helps. Regards, Serge Fonville

Re: [GENERAL] [NOOB] try tu put a number with pqexecprepare

: 'netinet/in.h': No such file or directory To resolve the lack of 'netinet/in.h' on Windows, take a look at uwin, gnuwin and libgw32c Hope this helps. Regards, Serge Fonville

Re: [GENERAL] serial

On Thu, Dec 4, 2008 at 3:42 PM, Gustavo Rosso <[EMAIL PROTECTED]> wrote: > I created this table: > > create table se (n serial); > > Column | Type | Modifiers > -+-+ > n | integer| not null defau

Re: [GENERAL] MySQL -> Postgres migration tools?

Hi, I googled for 'migrate mysql to postgresql' the first 5 results seem very useful. The most useful link I found was http://www.raditha.com/mysql/mysql2pgsql.php HTH Regards, Serge Fonville On Fri, Jan 22, 2010 at 8:15 PM, Erik Jones wrote: > Hello, > > Given that

Re: [GENERAL] Philosophical question

the rest it depends on the criteria for the app. HTH Just my 2ct Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Google!! They need to add GAL support on Android (star to agree) http://code.google.com/p/android/issues/detail?id=4602 2011/12/14 Andreas &

Re: [GENERAL] Stability in Windows?

Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Google!! They need to add GAL support on Android (star to agree) http://code.google.com/p/android/issues/detail?id=4602 2012/2/24 > We are using it on a rather beefy server with no problems with a Wi

Re: [GENERAL] Stability in Windows?

Doesn't http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_more_than_about_125_connections_at_once.2C_despite_having_capable_hardware apply? Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Google!!

Re: [GENERAL] How do I 'include' a stored procedure in a SQL script file

file Hope this helps Regards, Serge fonville On Wed, Jan 7, 2009 at 12:41 PM, Donna Rudd wrote: > Hi, > All I want to do is 'include' a stored procedure (contained in another > script file) into my main PostgreSQL database creation script file so that > it can get def

[GENERAL] PostgreSQL clustering with DRBD

advance, Serge Fonville

Re: [GENERAL] PostgreSQL clustering with DRBD

imary support for use with GFS/OCFS2 Perhaps it can be done without DRBD then? In many cases asynchronous replication is just not enough to model a certain > business case. Therefore Cybertec Schönig & Schönig GmbH offers a synchronous multimaster > replication solution for PostgreSQL called Cybercluster. Thanks, Serge Fonville

Re: [GENERAL] PostgreSQL clustering with DRBD

> > Serge Fonville wrote: > >> So, DRBD dual primary and Cybercluster multimaster, cannot be combined? >> > > If you have questions on Cybercluster, you should perhaps ask there for > details. For normal PostgreSQL, using DRBD dual primary is not possible. > You

Re: [GENERAL] Multiple postgres.exe On Processes

his way has been chosen by the developers Hope this helps Regards, Serge Fonville

Re: [GENERAL] Multiple postgres.exe On Processes

> > I have fear that sufficient increase in number of postgres.exe after one or > two logins on servers may down the speed of the server or even server. Is > there any solution or technique to overcome this overhead. > I did some more searching and foundIs PostgreSQL multi-threaded?

Re: [GENERAL] pg_hba reload

Hi, The swithc -d is for the directory that is populated when running initdb, it contains logging, configuration and databases Hope this helps Regards, Serge Fonville On Sat, Feb 14, 2009 at 11:10 PM, Bob Pawley wrote: > I am attempting to load postmaster. > > pg_ctl reload &g

Re: [GENERAL] PostgreSQL clustering with DRBD

supports a two node cluster. I think I start to have an idea about what the best suitable solution is for my situation. I was hoping there would be some sort of patch for the PostgreSQL download instead of an entire rebuild of the sources. I'll post any updates I find. Thanks a lot everyone Regards, Serge Fonville

Re: [GENERAL] postgresql with storage

database engines do you already have experience with Why do you want to know this (what is your endgoal) What have you already researched (googled) Are you migrating data or is it a new setup. What do the servers look like To name a few questions that come to mind Hope this helps Regards, Serge

Re: [GENERAL] postgresql with storage

> > The only meaningful benchmark is your application, all other benchmarks > only measure the performance of the benchmark. > As a benchmark you can also look into http://developer.postgresql.org/pgdocs/postgres/pgbench.html Hope this helps Regards, Serge Fonville

Re: [GENERAL] Matching against a field case in-sensitive.

> was stored. > PostgreSQL has string functions<http://developer.postgresql.org/pgdocs/postgres/functions-string.html> , you can use these in your where clause Hope this helps. Regards, Serge Fonville