Re: [GENERAL] Tablespace Default Behavior

On 03/30/2017 10:02 AM, harpagornis wrote: Nope, I installed v4.1.3 and it is the same, pg_default appears as the tablespace. Even when I use the drop down list in the right pane of PgAdmin to select the my_space tablespace, and then click the Save button, it does not change. pgAdmin is a sepa

Re: [GENERAL] Tablespace Default Behavior

Nope, I installed v4.1.3 and it is the same, pg_default appears as the tablespace. Even when I use the drop down list in the right pane of PgAdmin to select the my_space tablespace, and then click the Save button, it does not change. -- View this message in context: http://www.postgresql-archi

Re: [GENERAL] Tablespace Default Behavior

On 03/30/2017 08:36 AM, harpagornis wrote: Postgres version is 9.4 PgAdmin version is 1.0 Alright seems this is a known issue: https://redmine.postgresql.org/issues/2069 You will need a Postgres coummunity account: https://www.postgresql.org/account/signup/ to see the issue though. Thoug

Re: [GENERAL] Tablespace Default Behavior

Postgres version is 9.4 PgAdmin version is 1.0 The value returned by the suggested query is correctly reported as 'my_space'. -- View this message in context: http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5953046.html Sent from the PostgreSQL - general mailing list

Re: [GENERAL] Tablespace Default Behavior

On 03/30/2017 07:35 AM, harpagornis wrote: In PgAdmin, when I right-click the table, in the Properties pane on the right side of the screen, the tablespace is listed as "pg_default" What we know. Correct me if I am wrong: 1) In postgresql.conf you have: default_tablespace = '' 2) You created

Re: [GENERAL] Tablespace Default Behavior

In PgAdmin, when I right-click the table, in the Properties pane on the right side of the screen, the tablespace is listed as "pg_default" -- View this message in context: http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5953028.html Sent from the PostgreSQL - general ma

Re: [GENERAL] Tablespace Default Behavior

On 03/29/2017 09:18 PM, harpagornis wrote: That is what I suspected, and thank you for the explanation. I think it is misleading and a bug in PgAdmin for explicitly listing the tablespace as pg_default. Listing it where? -- View this message in context: http://www.postgresql-archive.org/

Re: [GENERAL] Tablespace Default Behavior

That is what I suspected, and thank you for the explanation. I think it is misleading and a bug in PgAdmin for explicitly listing the tablespace as pg_default. -- View this message in context: http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5952929.html Sent from the Po

Re: [GENERAL] Tablespace Default Behavior

harpagornis writes: > When I create a table, like this: > CREATE TABLE myschema.mytable (rc_id integer NOT NULL) TABLESPACE > my_space; > and then I do: > select * from pg_tables where schemaname ='myschema'; > the tablespace is blank for the new table. When I look in PgAdmin, the > tabl

Re: [GENERAL] Tablespace Default Behavior

More Info Edit: Also, the database is in the my_space tablespace. The location for the my_space tablespace is a different folder than the $PGDATA folder. -- View this message in context: http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910p5952917.html Sent from the Post

Re: [GENERAL] Tablespace limit feature

* Jim Nasby (jim.na...@bluetreble.com) wrote: > On 11/4/14, 2:10 PM, Alvaro Herrera wrote: > >Alejandro Carrillo escribió: > >>> > >>>But This feature is very necessary to control the amount space expensed by > >>>a postgresql user or tablespace. This feature could be used in PostgreSQL > >>>Shar

Re: [GENERAL] Tablespace limit feature

On 11/4/14, 2:10 PM, Alvaro Herrera wrote: Alejandro Carrillo escribió: > >But This feature is very necessary to control the amount space expensed by a postgresql user or tablespace. This feature could be used in PostgreSQL Sharing Hosting, see: Shared Database Hosting - PostgreSQL wiki Sure.

Re: [GENERAL] Tablespace limit feature

Alejandro Carrillo escribió: > > But This feature is very necessary to control the amount space expensed by a > postgresql user or tablespace. This feature could be used in PostgreSQL > Sharing Hosting, see: Shared Database Hosting - PostgreSQL wiki Sure. Rub hits the road when it comes to act

Re: [GENERAL] Tablespace limit feature

But This feature is very necessary to control the amount space expensed by a postgresql user or tablespace. This feature could be used in PostgreSQL Sharing Hosting, see: Shared Database Hosting - PostgreSQL wiki |   | |   |   |   |   |   | | Shared Database Hosting - PostgreSQL wikiThe objecti

Re: [GENERAL] Tablespace limit feature

* John R Pierce (pie...@hogranch.com) wrote: > On 11/4/2014 9:00 AM, Alejandro Carrillo wrote: > >I need to limit the tablespace file because I need to control the > >hard disk space used in a tablespace > > so what happens if a query does something that violates the quota? It gets cancelled. Se

Re: [GENERAL] Tablespace limit feature

On 11/4/2014 9:00 AM, Alejandro Carrillo wrote: I need to limit the tablespace file because I need to control the hard disk space used in a tablespace so what happens if a query does something that violates the quota? I can see one difficulty in implementation would be just keeping track of h

Re: [GENERAL] Tablespace limit feature

* Guillaume Lelarge (guilla...@lelarge.info) wrote: > Yeah. I guess there are a lot of questions yet to be answered. But AFAIUI, > there's no real technical issue. More like discussions to agree on what it > should do and how. Didn't mean to imply there was some specific technical issue. We have

Re: [GENERAL] Tablespace limit feature

On 11/04/2014 10:09 AM, Guillaume Lelarge wrote: Le 4 nov. 2014 18:00, "Alejandro Carrillo" > a écrit : > > I need to limit the tablespace file because I need to control the hard disk space used in a tablespace. Anybody knows how to do this? Or if it this in the Pos

Re: [GENERAL] Tablespace limit feature

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 4 Nov 2014 17:00:54 + (UTC), Alejandro Carrillo (faster...@yahoo.es) wrote about "Re: [GENERAL] Tablespace limit feature" (in <1781968257.697829.1415120454794.javamail.ya...@jws3.mail.ir2.yahoo.com>): > I need to l

Re: [GENERAL] Tablespace limit feature

Le 4 nov. 2014 17:59, "Stephen Frost" a écrit : > > * Guillaume Lelarge (guilla...@lelarge.info) wrote: > > Le 4 nov. 2014 16:29, "Stephen Frost" a écrit : > > > Having quotas and limits for users is something which I've wanted for a > > > long time, but it's not likely to happen any time particu

Re: [GENERAL] Tablespace limit feature

Le 4 nov. 2014 18:00, "Alejandro Carrillo" a écrit : > > I need to limit the tablespace file because I need to control the hard disk space used in a tablespace. Anybody knows how to do this? Or if it this in the PostgreSQL roadmap? > Well, Stephen already answered this. There's no way yet to do t

Re: [GENERAL] Tablespace limit feature

I need to limit the tablespace file because I need to control the hard disk space used in a tablespace. Anybody knows how to do this? Or if it this in the PostgreSQL roadmap? Thanks El Martes 4 de noviembre de 2014 11:52, Guillaume Lelarge escribió: Le 4 nov. 2014 16:29, "St

Re: [GENERAL] Tablespace limit feature

* Guillaume Lelarge (guilla...@lelarge.info) wrote: > Le 4 nov. 2014 16:29, "Stephen Frost" a écrit : > > Having quotas and limits for users is something which I've wanted for a > > long time, but it's not likely to happen any time particularly soon.. > > Lack of time or technical issue? For the

Re: [GENERAL] Tablespace limit feature

Le 4 nov. 2014 16:29, "Stephen Frost" a écrit : > > * Alejandro Carrillo (faster...@yahoo.es) wrote: > > Can PostgreSQL's tablespace limit space in MB? Or exists another way to limit space in a table of a tablespace?? > > You can set up quotas on the underlying filesystem, but that will limit > th

Re: [GENERAL] Tablespace limit feature

* Alejandro Carrillo (faster...@yahoo.es) wrote: > Can PostgreSQL's tablespace limit space in MB? Or exists another way to limit > space in a table of a tablespace?? You can set up quotas on the underlying filesystem, but that will limit the entire tablespace. Having quotas and limits for users

Re: [GENERAL] Tablespace limit feature

On 11/04/2014 07:05 AM, Alejandro Carrillo wrote: Hi, Can PostgreSQL's tablespace limit space in MB? Or exists another way to limit space in a table of a tablespace?? Not that I know of. What exactly is the issue you are facing? Maybe there is another way to achieve what you want. Thank

Re: [GENERAL] Tablespace on Postgrsql

On 7/24/2013 5:53 PM, devonline wrote: Our current database size is 1 Terabyte I would like to suggest that you pick a smaller system for your first experience with postgres, and work your way up to the big monster stuff after you've gained some experience. a terabyte database is a monste

Re: [GENERAL] Tablespace on Postgrsql

On 7/25/2013 10:16 PM, Atri Sharma wrote: On Fri, Jul 26, 2013 at 7:21 AM, devonline wrote: >Thanks for the in formation. Can you please tell me what would be a scalable >architecture? (using pg_default) or separate custom tablespaces Putting too may tables in one tablespace can lead to confu

Re: [GENERAL] Tablespace on Postgrsql

On Fri, Jul 26, 2013 at 7:21 AM, devonline wrote: > Thanks for the in formation. Can you please tell me what would be a scalable > architecture? (using pg_default) or separate custom tablespaces Putting too may tables in one tablespace can lead to confusion, to say the least. Keeping logically s

Re: [GENERAL] Tablespace on Postgrsql

Thanks for the in formation. Can you please tell me what would be a scalable architecture? (using pg_default) or separate custom tablespaces -- View this message in context: http://postgresql.1045698.n5.nabble.com/Tablespace-on-Postgrsql-tp5765056p5765219.html Sent from the PostgreSQL - ge

Re: [GENERAL] Tablespace on Postgrsql

On Thu, Jul 25, 2013 at 2:53 AM, devonline wrote: > Our current database size is > > 1 Terabyte > The idea behind tablespaces is to gain I/O scattering data (and therefore requests) across different devices. Therefore you have to identify first if your database can be "scattered" across different

Re: [GENERAL] Tablespace on Postgrsql

Our current database size is 1 Terabyte Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/Tablespace-on-Postgrsql-tp5765056p5765082.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] Tablespace on Postgrsql

On 7/24/2013 1:32 PM, devonline wrote: We do have large Database with RAID 10. we do have Replication(Hot backup) . we would like to have the same on PostgreSQL when we migrate to PostgreSQL . Should we create separate tablespaces for Database and its objects or pg_default is fine as you have

Re: [GENERAL] Tablespace on Postgrsql

We do have large Database with RAID 10. we do have Replication(Hot backup) . we would like to have the same on PostgreSQL when we migrate to PostgreSQL . Should we create separate tablespaces for Database and its objects or pg_default is fine as you have mentioned earlier Thanks a lot Dev Onli

Re: [GENERAL] Tablespace on Postgrsql

On 7/24/2013 12:31 PM, devonline wrote: I am new to PostgreSQL. I would like to know whether to use/pg_default/ Table space to create Database and its objetcs or to create custom Table space? I could not find what is recommended . tablespaces are usually only useful on very large scale se

Re: [GENERAL] tablespace directories

Hi Laurenz > That's the catalog version. > You can't get it from the catalogs AFAIK, but > the pg_controldata server utility will show > the information. Thanks! Much appreciated. I'm in a bash script, so it's fine. Cheers Bèrto -- == If Pac-Man had affected us as k

Re: [GENERAL] tablespace directories

Bèrto ëd Sèra wrote: > /PG_9.2_201204301/ > > the mystery is around the version_date (or so it would seem to be) part. That's the catalog version. You can't get it from the catalogs AFAIK, but the pg_controldata server utility will show the information. If you really need, you could wrap the exe

Re: [GENERAL] tablespace directories

Hi again, > /PG_9.2_201204301/417519 This should really have been written /PG_9.2_201204301/ the mystery is around the version_date (or so it would seem to be) part. Cheers Bèrto -- == If Pac-Man had affected us as kids, we'd all be running around in a darkened ro

Re: [GENERAL] - tablespace and directory

AFAIK, I dont see any catalog's giving that information. --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Wed, Apr 18, 2012 at 7:20 PM, F. BROUARD / SQLpro < sql...@club-internet.fr> wrote: > Hi, > > is there anyway to have the value of Catalog version nu

Re: [GENERAL] - tablespace and directory

Hi, is there anyway to have the value of Catalog version number in a query ? I do not see it in pg_settings... A + Le 18/04/2012 15:35, Raghavendra a écrit : On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro mailto:sql...@club-internet.fr>> wrote: Hi there, when creating a table

Re: [GENERAL] - tablespace and directory

On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro < sql...@club-internet.fr> wrote: > Hi there, > > when creating a tablespace pointing to an existing directory, PG create a > subderictory with this pattern : > > PG_???_! > > where ??? is the version (by instance 9.1) > > but I don't kn

Re: [GENERAL] - tablespace and directory

Thanks ! Le 18/04/2012 15:35, Raghavendra a écrit : On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro mailto:sql...@club-internet.fr>> wrote: Hi there, when creating a tablespace pointing to an existing directory, PG create a subderictory with this pattern : PG_???_!!

Re: [GENERAL] - tablespace and directory

On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro < sql...@club-internet.fr> wrote: > Hi there, > > when creating a tablespace pointing to an existing directory, PG create a > subderictory with this pattern : > > PG_???_! > > where ??? is the version (by instance 9.1) > > but I don't kn

Re: [GENERAL] Tablespace files deleted during continuous run

On Thu, Oct 13, 2011 at 10:32 PM, Scott Marlowe wrote: > On Thu, Oct 13, 2011 at 10:12 PM, Vishnu S. wrote: >> Hi, >> >> >> The tablespace is created using CREATE TABLESPACE query. > > Is it a local drive?  USB or eSATA maybe? Also is it formatted NTFS? FAT? remote mounted via a network share?

Re: [GENERAL] Tablespace files deleted during continuous run

On Thu, Oct 13, 2011 at 10:12 PM, Vishnu S. wrote: > Hi, > > > The tablespace is created using CREATE TABLESPACE query. Is it a local drive? USB or eSATA maybe? > Also Slony-I replication is working on the tablespace for Master - slave > implementation. should work. I've done it before with

Re: [GENERAL] Tablespace files deleted during continuous run

On Thu, Oct 13, 2011 at 6:55 AM, Vishnu S. wrote: > > I am using PostgreSQL 8.4 in windows.  I have  created a database and some > tables on it. Also created a table space and some tables in it. > > My application inserts data into these tables in every second. The > application is a continuous ru

Re: [GENERAL] Tablespace files deleted during continuous run

On Thu, Oct 13, 2011 at 6:55 AM, Vishnu S. wrote: > > > HI, > > I am using PostgreSQL 8.4 in windows.  I have  created a database and some > tables on it. Also created a table space and some tables in it. > > My application inserts data into these tables in every second. The > application is a con

Re: [GENERAL] Tablespace Issue

On Thu, Feb 17, 2011 at 4:08 AM, Adarsh Sharma wrote: > Dear all, > > Today I got to have a strong issue while craeting table in a database. > > pdc_uima=# create table clause2_naxal as select * from clause2 c > ,page_naxal_v3 p where c.source_id = p.crawled_page_id; > ERROR: could not extend re

Re: [GENERAL] tablespace restore

Vangelis, Did you find a best way to achieve what you were asking about? I have a similar desire to migrate a large table and its indices. Regards, Sky -- View this message in context: http://postgresql.1045698.n5.nabble.com/tablespace-restore-tp3272200p3361935.html Sent from the PostgreSQL -

Re: [GENERAL] tablespace restore

On 11/19/10 3:52 AM, Vangelis Katsikaros wrote: Hello I use postgres 8.3.12 on machineA and 8.4.5 on machineB. On machineA I have created a tablespace with CREATE TABLESPACE tablelocation_name LOCATION '/my/location/machineA'; I then created a database with CREATE DATABASE db_name TABLESPACE t

Re: [GENERAL] tablespace restore

The problem is that there is a lot of metadata outside the tablespace you created (information that the catalog tables keep on your new database and its objects) and this can only be restored with a full restore which would overwrite your pre-existing databases on your target. I hate to say it can

Re: [GENERAL] tablespace restore

On 11/19/2010 03:12 PM, Matthew Walden wrote: Vangelis, I don't believe you can do file level copying of single databases (especially as they are different versions). Hi Matthew, thanks for your answer. If the different versions is a problem, I can downgrade one server and then upgrade after

Re: [GENERAL] tablespace restore

Vangelis, I don't believe you can do file level copying of single databases (especially as they are different versions). Take a look at pg_dump in the documentation. This will do what you need I think but at a logical level rather than physical. On Fri, Nov 19, 2010 at 11:52 AM, Vangelis Katsik

Re: [GENERAL] Tablespace Problem

Kalai R writes: > I have found a problem in my database. The following error occurs sometime > not any specific database operation. > ERROR:XX000:count not create temporary file > "pg_tblspc/86014/pgsql_tmp/pgsql_tmp3568.0":No > such file or directory. Does that pgsql_tmp di

Re: [GENERAL] Tablespace

On Sun, Aug 05, 2007 at 04:03:10AM -0700, RPK wrote: > > When PGSQL is installed, it creates two default tablespaces, postgres and There is no postgres tablespace, only a database. The other default tablespace is pg_global. > pg_default. When a user creates a new database he is opted to select a

Re: [GENERAL] tablespace and backup

You will need to provide more information about the data requirement- such as column types, what you need to search for, and the actual queries and execution plans. Purely as a guess, it seems like you haven't tried partial indexes: http://www.postgresql.org/docs/8.1/interactive/sql-createindex.ht

Re: [GENERAL] tablespace spec

http://developer.postgresql.org Bruce Momjian wrote: David Parker wrote: Is there a spec/posting somewhere that more or less reflects how tablespaces are supposed to work in 7.5? I've found a lot of info on it by searching the archives, but I haven't found the posting that describes the basic func

Re: [GENERAL] tablespace spec

David Parker wrote: > Is there a spec/posting somewhere that more or less reflects how > tablespaces are supposed to work in 7.5? I've found a lot of info on it > by searching the archives, but I haven't found the posting that > describes the basic functionality. Have you looked at the development