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

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

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

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

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

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

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) >

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

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

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

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

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

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

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

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

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

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

Re: [GENERAL] Where in the source code does postgres write to disk?

On Fri, Apr 19, 2013 at 11:26 PM, Mike Levine wrote: > According to > http://www.postgresql.org/docs/9.2/static/storage-file-layout.html > > "When a table or index exceeds 1 GB, it is divided into gigabyte-sized > segments. The first segment's file name is the same as the filenode; > subsequent se

Re: [GENERAL] Where in the source code does postgres write to disk?

Hi, 2013/04/21 0:01, Mike Levine wrote: According tohttp://www.postgresql.org/docs/9.2/static/storage-file-layout.html "When a table or index exceeds 1 GB, it is divided into gigabyte-sized segments. The first segment's file name is the same as the filenode; subsequent segments are named fileno

Re: [GENERAL] Where Can I Find...

On 1/25/2013 8:21 AM, Gene Poole wrote: lso I don't want to use RPM because I like to control where software is installed. Another piece on information is that I am running on CentOS 5.8. if you don't want to use RPM, why did you choose an RPM based distribution? is '6 single sided DVDs'

Re: [GENERAL] Where Can I Find...

On Jan 25, 2013, at 8:21 AM, Gene Poole wrote: > I'm looking for a tutorial on how to move a Oracle 11gR2 database > that consists on 4 instances with table spaces spread across multiple file > systems to PostgreSQL. I need to do this because most of the open source CMS > packages do not pl

Re: [GENERAL] Where is 'createdb'?

Le jeudi 01 novembre 2012 à 16:49 -0500, Kevin Burton a écrit : > I watched while the OS was installed and it looked like postgres was > installed but the Ubuntu package apparently didn’t install it all or > it didn’t install it correctly. > to list the postgresql related packages installed on

Re: [GENERAL] Where is 'createdb'?

On 11/01/2012 02:49 PM, Kevin Burton wrote: I watched while the OS was installed and it looked like postgres was installed but the Ubuntu package apparently didn't install it all or it didn't install it correctly. You may have installed a portion of PostgreSQL - possibly just the client stu

Re: [GENERAL] Where is 'createdb'?

Zoltan Cc: Kevin Burton; pgsql-general@postgresql.org Subject: Re: [GENERAL] Where is 'createdb'? On 11/01/2012 02:10 PM, Boszormenyi Zoltan wrote: 2012-11-01 16:32 keltezéssel, Kevin Burton írta: ...I get ‘createdb command not found’. Are the authors out of date? What is the curre

Re: [GENERAL] Where is 'createdb'?

On 11/01/2012 02:10 PM, Boszormenyi Zoltan wrote: 2012-11-01 16:32 keltezéssel, Kevin Burton írta: ...I get 'createdb command not found'. Are the authors out of date? What is the current command? The instructions start with "Once you have Postgres installed...". Since the command is not ava

Re: [GENERAL] Where is 'createdb'?

2012-11-01 16:32 keltezéssel, Kevin Burton írta: This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here. I was trying to follow along in a book 'Seven Databases in Seven Weeks' and chapter 2 deals with PostgreSQL. One of the first

Re: [GENERAL] Where is 'createdb'?

On Fri, Nov 2, 2012 at 2:37 AM, Magnus Hagander wrote: > > On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton > wrote: >> >> The text before this command says, “Once >> you have Postgres installed, create a schema called book using the following >> command: $ createdb book’ > > The authors are incorrec

Re: [GENERAL] Where is 'createdb'?

Here is what i did on a Ubuntu linux server. I had installed postgres using apt-get install postgres. pkumar@ulinux1:~$ sudo su - postgres[sudo] password for pkumar: postgres@ulinux3:~$ createdb authDBpostgres@ulinux3:~$ createuser -P -l authuser You have to sudo into postgres or fix your clas

Re: [GENERAL] Where is 'createdb'?

On 11/01/2012 08:41 AM, Kevin Burton wrote: I type 'find createdb' and I get an error find: 'createdb' no such file or directory. Which exact OS/distribution/PostgreSQL-version are you using and how was PostgreSQL installed (OS-provided or 3rd-party)? The different packagers deal with thin

Re: [GENERAL] Where is 'createdb'?

What version of PostgreSQL did you install and how did you install it? I have 9.2.1 and it installed createdb into the default /usr/bin/ path, as did 9.1 and 9.0 before it (installed via yum in my case). On Thu, Nov 1, 2012 at 8:32 AM, Kevin Burton wrote: > This is probably a question for the au

Re: [GENERAL] Where is 'createdb'?

I type ‘find createdb’ and I get an error find: ‘createdb’ no such file or > directory. > > ** ** > > *From:* Magnus Hagander [mailto:mag...@hagander.net] > *Sent:* Thursday, November 01, 2012 10:38 AM > *To:* Kevin Burton > *Cc:* pgsql-general@postgresql.org > *Su

Re: [GENERAL] Where is 'createdb'?

I type 'find createdb' and I get an error find: 'createdb' no such file or directory. From: Magnus Hagander [mailto:mag...@hagander.net] Sent: Thursday, November 01, 2012 10:38 AM To: Kevin Burton Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Where is 'crea

Re: [GENERAL] Where is 'createdb'?

Torsdag 1. november 2012 16.32.42 skrev Kevin Burton : > This is probably a question for the authors of a book I have been reading > but it may be faster to get an answer here. > > > > I was trying to follow along in a book 'Seven Databases in Seven Weeks' and > chapter 2 deals with PostgreSQL.

Re: [GENERAL] Where is 'createdb'?

On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton wrote: > This is probably a question for the authors of a book I have been reading > but it may be faster to get an answer here. > > ** ** > > I was trying to follow along in a book ‘Seven Databases in Seven Weeks’ > and chapter 2 deals with Postgre

Re: [GENERAL] Where do I get pgAdmin 1.16 for openSuSE?

On Thu, Sep 13, 2012 at 12:15 AM, Devrim GÜNDÜZ wrote: > > Hi, > > On Wed, 2012-09-12 at 20:51 -0700, Mike Christensen wrote: >> In file included from ../pgadmin/include/pgAdmin3.h:24:0, >> from ./pgAdmin3.cpp:13: >> ../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/st

  1   2   3   4   >