Re: [GENERAL] Where to find development builds of pg for windows

On Sat, Oct 28, 2017 at 02:18:52AM -0700, legrand legrand wrote: > Subject: Re: [GENERAL] Where to find development builds of pg for windows ... > I will be [...] pg 10 new features testing You can't because it's released. If you need dev builds of PG10 you'll probably have

Re: [GENERAL] Where to find development builds of pg for windows

Thanks, Yes I will be busy with pg 10 new features testing ;o) Nb: I also have installed a unix partition to be able to test non-core extensions and prototypes Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing

Re: [GENERAL] Where to find development builds of pg for windows

On Sat, Oct 14, 2017 at 12:18 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Hello, > > Using PG mainly on windows, I would have liked to test new releases / > development versions before they are available in > https://www.postgresql.org/download/windows/ > > Are there some build far

[GENERAL] Where to find development builds of pg for windows

Hello, Using PG mainly on windows, I would have liked to test new releases / development versions before they are available in https://www.postgresql.org/download/windows/ Are there some build farms or places where I could find "build snapshots for windows" without having to build them by myself

Re: [GENERAL] Where is pg_hba.conf

Hello, On Sun, Aug 13, 2017 at 10:00:23AM -0400, Igor Korot wrote: > However, I can't find this file anywhere on the system. > I am able to connec to the server locally with psql. I can also > connect to the server > from the ODBC driver from my program. However doing a global search I > can't fin

Re: [GENERAL] Where is pg_hba.conf

On Sun, 13 Aug 2017 10:55:00 -0400, Igor Korot wrote: >Also, I presume that the address in this file is the address of the >machine where the server is located, not the address from where the >connection is initiated. No. The addresses / network segments in the file specify from where the clien

Re: [GENERAL] Where is pg_hba.conf

On Sunday, August 13, 2017, Igor Korot wrote: > Also, I presume that the address in this file is the address of the > machine where the server is located, not the address from where the > connection is initiated. > Not according to the docs. https://www.postgresql.org/docs/current/static/auth-p

Re: [GENERAL] Where is pg_hba.conf

Also, I presume that the address in this file is the address of the machine where the server is located, not the address from where the connection is initiated. On Sun, Aug 13, 2017 at 10:53 AM, Igor Korot wrote: > Hi, > OK, I found it under the root account. > > Now I am modifying it as follows

Re: [GENERAL] Where is pg_hba.conf

Hi, OK, I found it under the root account. Now I am modifying it as follows: # TYPE DATABASEUSERADDRESS METHOD # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: h

Re: [GENERAL] Where is pg_hba.conf

Re: Igor Korot 2017-08-13 > draft=# SHOW hba_file > draft-# SHOW hba_file; > ERROR: syntax error at or near "SHOW" > LINE 2: SHOW hba_file; > ^ Standard beginners error. If you forgot the ";" on the first line, it'll process both lines as a single, erroneous command. Note the "

Re: [GENERAL] Where is pg_hba.conf

Hi, armand, On Sun, Aug 13, 2017 at 10:12 AM, armand pirvu wrote: > Normally should reside in the data dir. My case below > > armandps-MacBook-Air:~ armandp$ ps -fu postgres |grep data > 502 29591 1 0 Thu09PM ?? 0:01.63 > /Library/PostgreSQL/9.6/bin/postgres -D /Library/PostgreSQL

Re: [GENERAL] Where is pg_hba.conf

Hi, Christoph, On Sun, Aug 13, 2017 at 10:09 AM, Christoph Berg wrote: > Re: Igor Korot 2017-08-13 > >> I need to modify the pg_hba.conf file to get access to the DB >> remotely. >> >> However, I can't find this file anywhere on the system. > > Try "SHOW hba_file;". Last login: Sat Aug 12 23:4

Re: [GENERAL] Where is pg_hba.conf

Normally should reside in the data dir. My case below armandps-MacBook-Air:~ armandp$ ps -fu postgres |grep data 502 29591 1 0 Thu09PM ?? 0:01.63 /Library/PostgreSQL/9.6/bin/postgres -D /Library/PostgreSQL/9.6/data armandps-MacBook-Air:~ armandp$ ls -l /Library/PostgreSQL/9.6/dat

Re: [GENERAL] Where is pg_hba.conf

Re: Igor Korot 2017-08-13 > I need to modify the pg_hba.conf file to get access to the DB > remotely. > > However, I can't find this file anywhere on the system. Try "SHOW hba_file;". Christoph -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

[GENERAL] Where is pg_hba.conf

Hi, I have a Mac with OSX 10.8 installed. It has Postgre 9.1. According to https://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html and http://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/?utm_source=tuicool I need to modify the pg_hba.conf file to get access to the DB

Re: [GENERAL] Where is the error?

## Igor Korot (ikoro...@gmail.com): > Another question - do I have to do "DECLARE CURSOR..." or I can just write > a normal SELECT query? > For this I followed and example on the libpg page... Yes. In fact, "libpq Example Program 3" on https://www.postgresql.org/docs/current/static/libpq-example.

Re: [GENERAL] Where is the error?

Hi, Christoph, On May 6, 2017 2:24 PM, "Christoph Moench-Tegeder" wrote: ## Igor Korot (ikoro...@gmail.com): > std::string query1 = "DECLARE alltables CURSOR SELECT > table_schema, table_name FROM information_schema.tables WHERE > table_type = 'BASE TABLE' OR table_type = 'VIEW' OR table_

Re: [GENERAL] Where is the error?

## Igor Korot (ikoro...@gmail.com): > std::string query1 = "DECLARE alltables CURSOR SELECT > table_schema, table_name FROM information_schema.tables WHERE > table_type = 'BASE TABLE' OR table_type = 'VIEW' OR table_type = > 'LOCAL TEMPORARY';"; > [quote] > RROR: syntax error at or near "SEL

[GENERAL] Where is the error?

Hi, ALL, I am trying to execute following piece of code: [code] std::string query1 = "DECLARE alltables CURSOR SELECT table_schema, table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' OR table_type = 'VIEW' OR table_type = 'LOCAL TEMPORARY';"; res = PQexec( m_db, quer

Re: [GENERAL] Where is the libpg on OSX?

On 05/04/2017 08:54 PM, Igor Korot wrote: Hi, ALL, [code] Igors-MacBook-Air:/ igorkorot$ find . -name *libpg* Pretty sure what you are looking for is libpq: https://www.postgresql.org/docs/9.6/static/libpq.html And then doing this: [code] Igors-MacBook-Air:/ igorkorot$ pg_config --libs -l

[GENERAL] Where is the libpg on OSX?

Hi, ALL, [code] Igors-MacBook-Air:/ igorkorot$ find . -name *libpg* find: ./.DocumentRevisions-V100: Permission denied find: ./.fseventsd: Permission denied find: ./.Spotlight-V100: Permission denied find: ./.Trashes: Permission denied ./Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.p

Re: [GENERAL] Where would I be able to get instructions regarding postgresql installation on Windows 10?

Just click on the version of Win x-86 32 PostgreSQL you want from here and use the downloaded installer. http://www.enterprisedb.com/products-services-training/pgdownload#windows On Sun, Dec 4, 2016 at 7:57 PM, Varuna Seneviratna < varunasenevira...@gmail.com> wrote: > Hello, > I looked

[GENERAL] Where would I be able to get instructions regarding postgresql installation on Windows 10?

Hello, I looked through the documentation But was not able to find any information. If possible please guide me Varuna

Re: [GENERAL] Where to download pgbench for Windows 7

Thank you, John. On Dec 2, 2016 23:12, "John R Pierce" wrote: > On 12/2/2016 10:37 PM, James Zhou wrote: > >> I am new to PostgreSQL and am leaning it. I installed PostgreSQL on a >> Windows 7 laptop and would like to play with pgbench to generate a sample >> database and a bit load. >> >> As I

Re: [GENERAL] Where to download pgbench for Windows 7

On 12/2/2016 10:37 PM, James Zhou wrote: I am new to PostgreSQL and am leaning it. I installed PostgreSQL on a Windows 7 laptop and would like to play with pgbench to generate a sample database and a bit load. As I read, pgbench should come with the server download. But after I install it, I

[GENERAL] Where to download pgbench for Windows 7

Hi, I am new to PostgreSQL and am leaning it. I installed PostgreSQL on a Windows 7 laptop and would like to play with pgbench to generate a sample database and a bit load. As I read, pgbench should come with the server download. But after I install it, I could find pgbench: [image: Inline image

Re: [GENERAL] WHERE ... IN condition and multiple columns in subquery

Thank you for the advices and I have also got few answers at http://stackoverflow.com/questions/40304011/where-in-condition-and-multiple-columns-in-subquery Regards Alex

Re: [GENERAL] WHERE ... IN condition and multiple columns in subquery

On 28 October 2016 at 13:03, Alexander Farber wrote: > Hello, > > is it please possible to rewrite the SQL query > > SELECT DISTINCT ON (uid) > uid, > female, > given, > photo, > place > FROM words_social > WHERE uid I

Re: [GENERAL] WHERE ... IN condition and multiple columns in subquery

On 28 October 2016 at 12:03, Alexander Farber wrote: > is it please possible to rewrite the SQL query > > SELECT DISTINCT ON (uid) > uid, > female, > given, > photo, > place > FROM words_social > WHERE uid IN (SELECT

Re: [GENERAL] WHERE ... IN condition and multiple columns in subquery

Alexander Farber writes: > is it please possible to rewrite the SQL query > SELECT DISTINCT ON (uid) > uid, > female, > given, > photo, > place > FROM words_social > WHERE uid IN (SELECT player1 FROM games) >

[GENERAL] WHERE ... IN condition and multiple columns in subquery

Hello, is it please possible to rewrite the SQL query SELECT DISTINCT ON (uid) uid, female, given, photo, place FROM words_social WHERE uid IN (SELECT player1 FROM games) OR uid IN (SELECT player2 FROM

Re: [GENERAL] Where do I enter commands?

Hello David, This cookbook has worked for me for the last five years on Mac OS X, always and totally reliable up to incl. El Capitan and every intermittent release before. And most of all, it worked even as a repair measure. So if my server would stop working after a small Mac Os X update, I to

Re: [GENERAL] Where do I enter commands?

On Sun, Oct 25, 2015 at 07:57:48AM -0700, David Blomstrom wrote: > I can see PostgreSQL is going to have a learning curve - hopefully shorter > than the years it took me to learn MySQL - but it looks interesting. The > community seems painfully small compared to MySQL, and there are less > online r

Re: [GENERAL] Where do I enter commands?

No problem. I'm pretty grumpy when people invade MY turf - biology and education reform. As a former Seattle teacher who spent sixteen years in the meat grinder before becoming a whistle-blower, I've seen it all - and I know it all. ;) On Sun, Oct 25, 2015 at 8:41 AM, Karsten Hilbert wrote: > On

Re: [GENERAL] Where do I enter commands?

On Sun, Oct 25, 2015 at 08:32:43AM -0700, David Blomstrom wrote: > Someone said when you add a new column in Postgre, it's appended to the end > of the table. Does that mean that's where it has to stay, or can you > rearrange columns No, unless you drop/re-create the table (manually or with

Re: [GENERAL] Where do I enter commands?

> On Oct 25, 2015, at 3:21 AM, Joshua D. Drake wrote: > > I would ignore Rob, he obviously is suffering from a lack of coffee. Our > community always tries to help new users. It is great to see you here. > > Sincerely, > > JD > Always the best advice :) OK, Coffee’d up now. Apologies for

Re: [GENERAL] Where do I enter commands?

Wow, great tips; you answered a question I was about to post either here or on a forum. One question, though. Someone said when you add a new column in Postgre, it's appended to the end of the table. Does that mean that's where it has to stay, or can you rearrange columns, as in MySQL? On Sun, Oc

Re: [GENERAL] Where do I enter commands?

On 10/25/2015 07:57 AM, David Blomstrom wrote: It's hard to imagine creating a table with a command-line tool - in the step-by-step process I use with phpMyAdmin, that is. If you can learn the proper syntax for creating a table and put together a script for a generic table that you can easily mod

Re: [GENERAL] Where do I enter commands?

On Sun, Oct 25, 2015 at 07:57:48AM -0700, David Blomstrom wrote: > In phpMyAdmin, I've become accustomed to simply copying existing tables, > then adding, deleting and renaming columns as needed. Oh! Interesting. I suspect you're actually _undermining_ your ability to use the database (because o

Re: [GENERAL] Where do I enter commands?

It's hard to imagine creating a table with a command-line tool - in the step-by-step process I use with phpMyAdmin, that is. If you can learn the proper syntax for creating a table and put together a script for a generic table that you can easily modify, then maybe it would be a lot easier with a c

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 09:19 PM, David Blomstrom wrote: I'm a writer. I studied programing and MySQL so I could create websites that I can publish my articles to. I don't have time to keep up with the endless technology - MySQL, PDO, stored procedures, PHP, JavaScript, JQuery, and on and on - especially w

Re: [GENERAL] Where do I enter commands?

Since you are just starting, you should probably familarize yourself with how PgAdmin works with PostgreSQL. Therefore, it is best you refer to the documentation for PgAdmin. PgAdmin III http://www.pgadmin.org/docs/1.20/index.html I also suggest you obtain a copy of one, or both, of the following

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 09:19 PM, David Blomstrom wrote: I'm a writer. I studied programing and MySQL so I could create websites that I can publish my articles to. I don't have time to keep up with the endless technology - MySQL, PDO, stored procedures, PHP, JavaScript, JQuery, and on and on - especially w

Re: [GENERAL] Where do I enter commands?

On Sat, Oct 24, 2015 at 07:33:15PM -0700, David Blomstrom wrote: > It seems like a command-line tool would be > incredibly tedious when creating tables, modifying them, filling them with > data, etc. For whatever it's worth, I find quite the opposite: once you have the hang of the command line, it

Re: [GENERAL] Where do I enter commands?

I'm a writer. I studied programing and MySQL so I could create websites that I can publish my articles to. I don't have time to keep up with the endless technology - MySQL, PDO, stored procedures, PHP, JavaScript, JQuery, and on and on - especially when I have to work for a living. I've been using

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 08:52 PM, Rob Sargent wrote: ok. now who has the url to the pithy heres-why-you-/really/-want-the-command-line. It distills to something about actually knowing what you’re doing. Everyone has to start somewhere. The point is get someone using Postgres in manner they are comforta

Re: [GENERAL] Where do I enter commands?

ok. now who has the url to the pithy heres-why-you-really-want-the-command-line. It distills to something about actually knowing what you’re doing. > On Oct 24, 2015, at 9:29 PM, David Blomstrom > wrote: > > Good tip; I can now see the database I created. Thanks. > > On Sat, Oct 24, 2015

Re: [GENERAL] Where do I enter commands?

Good tip; I can now see the database I created. Thanks. On Sat, Oct 24, 2015 at 8:20 PM, Adrian Klaver wrote: > On 10/24/2015 08:00 PM, David Blomstrom wrote: > >> "Is there a entry under Servers?" >> >> PostgreSQL 9.5 (localhost) - but there's a red X over it. >> > > That means you are not conn

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 08:00 PM, David Blomstrom wrote: "Is there a entry under Servers?" PostgreSQL 9.5 (localhost) - but there's a red X over it. That means you are not connected to the Server. Right click on the entry and select Connect. It will probably ask for a password, which should be the dat

Re: [GENERAL] Where do I enter commands?

"Is there a entry under Servers?" PostgreSQL 9.5 (localhost) - but there's a red X over it. On Sat, Oct 24, 2015 at 7:52 PM, Adrian Klaver wrote: > On 10/24/2015 07:44 PM, David Blomstrom wrote: > >> Hmmm...I have pgAdminIII. When I click on Server, there's no option to >> create a database. >>

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 07:44 PM, David Blomstrom wrote: Hmmm...I have pgAdminIII. When I click on Server, there's no option to create a database. I would spend some time here: http://www.pgadmin.org/docs/1.20/index.html before going much further, just to get the gist of pgAdmin. In the meantime, you

Re: [GENERAL] Where do I enter commands?

Hmmm...I have pgAdminIII. When I click on Server, there's no option to create a database. On Sat, Oct 24, 2015 at 7:37 PM, John R Pierce wrote: > On 10/24/2015 7:33 PM, David Blomstrom wrote: > >> I'd greatly prefer a GUI. It seems like a command-line tool would be >> incredibly tedious when cre

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 7:33 PM, David Blomstrom wrote: I'd greatly prefer a GUI. It seems like a command-line tool would be incredibly tedious when creating tables, modifying them, filling them with data, etc. Thanks. normally, your application programs do the data filling part, manual data entry di

Re: [GENERAL] Where do I enter commands?

I'd greatly prefer a GUI. It seems like a command-line tool would be incredibly tedious when creating tables, modifying them, filling them with data, etc. Thanks. On Sat, Oct 24, 2015 at 7:28 PM, Adrian Klaver wrote: > On 10/24/2015 07:20 PM, David Blomstrom wrote: > >> I'm on a Mac running OS X

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 07:20 PM, David Blomstrom wrote: I'm on a Mac running OS X El Capitain. I think I installed PostgreSQL 9.5 after following the links to http://www.enterprisedb.com/products-services-training/pgdownload#osx Well the tutorial is geared to using the command line to run programs. Are

Re: [GENERAL] Where do I enter commands?

I'm on a Mac running OS X El Capitain. I think I installed PostgreSQL 9.5 after following the links to http://www.enterprisedb.com/products-services-training/pgdownload#osx I just learned about phpPGAdmin and installed it as well. But when I navigate to localhost/phppgadmin, I get a "not found" er

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 06:21 PM, David Blomstrom wrote: I just installed PostgreSQL and started reading the tutorial @ http://www.postgresql.org/docs/8.0/static/tutorial-createdb.html and was snowed at square one. To create a database, I'm supposed to type the following command: $ createdb mydb But it

[GENERAL] Where do I enter commands?

I just installed PostgreSQL and started reading the tutorial @ http://www.postgresql.org/docs/8.0/static/tutorial-createdb.html and was snowed at square one. To create a database, I'm supposed to type the following command: $ createdb mydb But it doesn't say where I'm supposed to type it. When I

Re: [GENERAL] Where to place suggestions for documentation improvements

gt; To: Charles Clavadetscher > Cc: PostgreSQL mailing lists > Subject: Re: [GENERAL] Where to place suggestions for documentation > improvements > > On Tue, Jul 14, 2015 at 8:17 PM, Charles Clavadetscher > wrote: > > I have a generic question. Where should I/we place suggesti

Re: [GENERAL] Where to place suggestions for documentation improvements

On Tue, Jul 14, 2015 at 8:17 PM, Charles Clavadetscher wrote: > I have a generic question. Where should I/we place suggestions on possible > improvements of the documentation? Is it here or better on pgsql-docs? pgsql-docs may be a better place than this list dedicated to general questions, still

[GENERAL] Where to place suggestions for documentation improvements

Hello I have a generic question. Where should I/we place suggestions on possible improvements of the documentation? Is it here or better on pgsql-docs? Thanks Charles -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgr

Re: [GENERAL] Where does vacuum FULL write temp-files?

På fredag 17. april 2015 kl. 00:05:47, skrev Guillaume Lelarge < guilla...@lelarge.info >: 2015-04-15 10:46 GMT+02:00 Andreas Joseph Kroghmailto:andr...@visena.com>>: På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N mailto:nag1...@gmail.com>>:   I'm pla

Re: [GENERAL] Where does vacuum FULL write temp-files?

2015-04-15 10:46 GMT+02:00 Andreas Joseph Krogh : > På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N < > nag1...@gmail.com>: > > > >> I'm planning to vacuum FULL a pg_largeobject relation (after vacuumlo'ing >> it). The relation is 300GB large so I'm concerned the operation will write

Re: [GENERAL] Where does vacuum FULL write temp-files?

På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N mailto:nag1...@gmail.com>>:   I'm planning to vacuum FULL a pg_largeobject relation (after vacuumlo'ing it). The relation is 300GB large so I'm concerned the operation will write full my pg_xlog directory which is on a 200GB (net) RAI

Re: [GENERAL] Where does vacuum FULL write temp-files?

> I'm planning to vacuum FULL a pg_largeobject relation (after vacuumlo'ing > it). The relation is 300GB large so I'm concerned the operation will write > full my pg_xlog directory which is on a 200GB (net) RAID1 SSD. > > Where does vacuum FULL rewrite to, does it use pg_xlog or some other > direct

[GENERAL] Where does vacuum FULL write temp-files?

Hi all.   I'm planning to vacuum FULL a pg_largeobject relation (after vacuumlo'ing it). The relation is 300GB large so I'm concerned the operation will write full my pg_xlog directory which is on a 200GB (net) RAID1 SSD.   Where does vacuum FULL rewrite to, does it use pg_xlog or some other dir

Re: [GENERAL] Where should I post 3rd party product announcements?

> On Tue, Oct 14, 2014 at 3:12 PM, Jonathan Neve wrote: > > > I tried pg-announce as well, but my message didn't go through… The message is not in the moderation queue, so it must have been flagged as spam. Without having seen it, a priori I don't think it's completely inappropriate for pgsql-a

Re: [GENERAL] Where should I post 3rd party product announcements?

Thanks, I'll give that a try! Jonathan Le 14/10/14 12:01, Magnus Hagander a écrit : It's on http://www.postgresql.org/, click the link that says "Submit news". //Magnus On Tue, Oct 14, 2014 at 11:55 AM, Jonathan Neve wrote: Sorry for being a bit dense, but where should I submit a website ne

Re: [GENERAL] Where should I post 3rd party product announcements?

It's on http://www.postgresql.org/, click the link that says "Submit news". //Magnus On Tue, Oct 14, 2014 at 11:55 AM, Jonathan Neve wrote: > Sorry for being a bit dense, but where should I submit a website news > posting ? > > Le mardi 14 octobre 2014 11:45:55, Magnus Hagander a écrit : >> >>

Re: [GENERAL] Where should I post 3rd party product announcements?

Sorry for being a bit dense, but where should I submit a website news posting ? Le mardi 14 octobre 2014 11:45:55, Magnus Hagander a écrit : On Tue, Oct 14, 2014 at 11:42 AM, Jonathan Neve wrote: Hello Amit, I tried pg-announce as well, but my message didn't go through… Not having seen

Re: [GENERAL] Where should I post 3rd party product announcements?

On Tue, Oct 14, 2014 at 11:42 AM, Jonathan Neve wrote: > Hello Amit, > > I tried pg-announce as well, but my message didn't go through… Not having seen the actual post, it may have been moderated based on the rules at https://wiki.postgresql.org/wiki/NewsEventsApproval. These are primarily for we

Re: [GENERAL] Where should I post 3rd party product announcements?

On Tue, Oct 14, 2014 at 3:12 PM, Jonathan Neve wrote: > Hello Amit, > > I tried pg-announce as well, but my message didn't go through… > > Jonathan > > Le mardi 14 octobre 2014 11:38:02, Amit Langote a écrit : > > On Tue, Oct 14, 2014 at 4:58 PM, Jonathan Neve >> wrote: >> >>> Hello, >>> >>> I

Re: [GENERAL] Where should I post 3rd party product announcements?

Hello Amit, I tried pg-announce as well, but my message didn't go through… Jonathan Le mardi 14 octobre 2014 11:38:02, Amit Langote a écrit : On Tue, Oct 14, 2014 at 4:58 PM, Jonathan Neve wrote: Hello, I am the author of a database replication solution to which I recently added Postgres su

Re: [GENERAL] Where should I post 3rd party product announcements?

On Tue, Oct 14, 2014 at 4:58 PM, Jonathan Neve wrote: > Hello, > > I am the author of a database replication solution to which I recently added > Postgres support. I would like to let the PG community know about it and I > therefore posted a message to this list, but it didn't come through, > pres

[GENERAL] Where should I post 3rd party product announcements?

Hello, I am the author of a database replication solution to which I recently added Postgres support. I would like to let the PG community know about it and I therefore posted a message to this list, but it didn't come through, presumably because it was considered to be spam. Where would be

Fwd: Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

On September 23, 2014 2:27:29 PM EDT, Adrian Klaver wrote: On 09/23/2014 11:05 AM, Nick Guenther wrote: Quoting Seref Arikan : On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer wrote: Hi all I've had some issues with how the procedural languages are packaged in the Windows installer

Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

On Tue, Sep 23, 2014 at 11:05 AM, Nick Guenther wrote: > I've struggled with plpython on OpenBSD 5.5-amd64 as well. Could it be related? Maybe the amount of dependencies python pulls in gets overwhelming and things break? > > > $ psql -h localhost -d postgres > psql (9.3.2) > Type "help" for help.

Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

On 09/23/2014 11:05 AM, Nick Guenther wrote: Quoting Seref Arikan : On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer wrote: Hi all I've had some issues with how the procedural languages are packaged in the Windows installer for a while, but I was very surprised to see that plpython2 appears

Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

On Tuesday, September 23, 2014 02:05:48 PM Nick Guenther wrote: > I uninstalled all the postgres subpackages and rebuilt them from > ports, and ended up with an identical plpython2.so, which has these > checksums: > SHA256 (/usr/local/lib/postgresql/plpython2.so) = > 8c7ff6358d9bf0db342e3aca1762cd7

Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

Quoting Seref Arikan : On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer wrote: Hi all I've had some issues with how the procedural languages are packaged in the Windows installer for a while, but I was very surprised to see that plpython2 appears to be entirely absent in 9.3. It doesn't seem

Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

Craig Ringer 2ndquadrant.com> writes: > I've had some issues with how the procedural languages are packaged in > the Windows installer for a while, but I was very surprised to see that > plpython2 appears to be entirely absent in 9.3. > > It doesn't seem to be provided via EDB's StackBuilder app

Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

I've gone through the same journey myself. Tried to juggle dlls etc. Apparently python 2 is no longer included in the windows installer. Since I have lots of python 2.x code with native extensions etc, I thought about compiling postgres from source on Windows but as usual the process turned into a

[GENERAL] Where art thou, plpython2.dll? (EDB installer)

Hi all I've had some issues with how the procedural languages are packaged in the Windows installer for a while, but I was very surprised to see that plpython2 appears to be entirely absent in 9.3. It doesn't seem to be provided via EDB's StackBuilder app either. What's going on? It looks like i

Re: [GENERAL] Where can I download PostgreSQL 9.4 for AIX 6?

On 08/08/2014 01:45 PM, Deb Brooks wrote: Thank you for the prompt reply and the advice. If you are going to compile from source the following might come in handy: http://www.postgresql.org/docs/9.4/static/installation-platform-notes.html#INSTALLATION-NOTES-AIX -- Adrian Klaver adrian.kla.

Re: [GENERAL] Where can I download PostgreSQL 9.4 for AIX 6?

Thank you for the prompt reply and the advice. This email and any files transmitted with it are confidential, proprietary and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please delete it immediately.

Re: [GENERAL] Where can I download PostgreSQL 9.4 for AIX 6?

On 8/8/2014 1:30 PM, Deb Brooks wrote: I am not sure how to find the download file for PostgreSQL 9.4 on AIX 6. Would someone point me to the correct location? AFAIK, you have to compile it yourself from source, and I'd recommend using IBM XL C rather than GCC. At least, thats what I've been

[GENERAL] Where can I download PostgreSQL 9.4 for AIX 6?

I am not sure how to find the download file for PostgreSQL 9.4 on AIX 6. Would someone point me to the correct location? This email and any files transmitted with it are confidential, proprietary and intended solely for the individual or entity to whom they are addressed. If you have received

Re: [GENERAL] Where the core files are generated in running postgres server

On Mon, Aug 4, 2014 at 7:56 PM, M Tarkeshwar Rao wrote: > Is it always creating core files on /var/lib/postgresql/8.4/main path for > ubuntu? I don't recall for ubuntu, but on Linux for sure you can see how a core file is shaped by looking at /proc/sys/kernel/core_pattern. Just noticing something.

Re: [GENERAL] Where the core files are generated in running postgres server

Hi Asif, Is it always creating core files on /var/lib/postgresql/8.4/main path for ubontu? i.e. in data directory. Regards Tarkeshwar From: Asif Naeem [mailto:anaeem...@gmail.com] Sent: 04 August 2014 16:01 To: M Tarkeshwar Rao Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Where the

Re: [GENERAL] Where the core files are generated in running postgres server

Hi Tarkeshwar, If you are using Unix/Linux following link might be useful to you i.e. https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Enabling_core_dumps Regards, Muhammad Asif Naeem On Mon, Aug 4, 2014 at 3:19 PM, M Tarkeshwar Rao < m.tarkesh

[GENERAL] Where the core files are generated in running postgres server

Hi all, I want to know the exact path of the core files generated by Postgres server during crash? Can I configure it or generate it? Regards Tarkeshwar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailp

Re: [GENERAL] Where can I find the 9.3 beta1 rpm now ?

On 11/06/2013 12:56 AM, Massimo Ortensi wrote: Hi everybody. I downloaded and tested 9.3 beta 1 back in june and used for a while. Today I upgraded to 9.3.1 but just discovered that database cannot be directly used, so I need to switch back to the beta version in order to dump the data. Is there

[GENERAL] Where can I find the 9.3 beta1 rpm now ?

Hi everybody. I downloaded and tested 9.3 beta 1 back in june and used for a while. Today I upgraded to 9.3.1 but just discovered that database cannot be directly used, so I need to switch back to the beta version in order to dump the data. Is there any site I can download the old beta rpm's ?

[GENERAL] Where can I find the 9.3 beta1 rpm now ?

Hi everybody. I downloaded and tested 9.3 beta 1 back in june and used for a while. Today I upgraded to 9.3.1 but just discovered that database cannot be directly used, so I need to switch back to the beta version in order to dump the data. Is there any site I can download the old beta rpm's ?

Re: [GENERAL] WHERE 'Something%' LIKE ANY (array_field)

Tim Kane wrote: > I'm using a single LIKE clause against an array parameter, rather > than multiple LIKE clauses against a single parameter. The problem is that you have the arguments to the LIKE parameter reversed with the attempts you show.  Try something like this: select * from ids   where

Re: [GENERAL] WHERE 'Something%' LIKE ANY (array_field)

Thanks Pavel, Unless I'm being bleary eyed and not quite grasping it... I'm not sure that answers my question. I'm using a single LIKE clause against an array parameter, rather than multiple LIKE clauses against a single parameter. It seems I'm so far stuck with a FOREACH style traversal within

Re: [GENERAL] WHERE 'Something%' LIKE ANY (array_field)

Hello http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#LIKE_to_list_of_patterns Regards Pavel Stehule 2013/8/14 Tim Kane > Hi all, > > It seems like it isn't possible to perform a wildcard LIKE evaluation > against array objects. Is this a bug, or just unsupported? > > > See the queries in bold

[GENERAL] WHERE 'Something%' LIKE ANY (array_field)

Hi all, It seems like it isn't possible to perform a wildcard LIKE evaluation against array objects. Is this a bug, or just unsupported? See the queries in bold, that I would have expected to return a value. Postgres 9.1.9 =# create temp table ids (id varchar(12)[]); CREATE TABLE Time: 185.516

Re: [GENERAL] Where to set search_path

Jeff Janes wrote > I've have an application which uses the public schema for all of its > relations. > > I want to change the name of the schema (in preparation to merging the > database into that of another application, which also uses the public > schema for its tables). > > I could qualify all

[GENERAL] Where to set search_path

I've have an application which uses the public schema for all of its relations. I want to change the name of the schema (in preparation to merging the database into that of another application, which also uses the public schema for its tables). I could qualify all of the tables and sequence with

  1   2   3   4   5   >